How can we draw a line chart

The line chart is mainly used to show the trends in data and is also one of the most commonly used chart styles at work. This table shows the number of newly hired employees and the number of employees who resigned from the company from 2000 to 2021. So how can we quickly generate a line chart on this? 1. Select all the data in column B. 2. Click the Chart button in the Insert tab, and choose the Line option. In this way, we can get a simple line chart.If we modify the data in the data....

Create the double-layer doughnut chart

The double-layer doughnut chart can visually display the proportion of multiple data. As shown in the chart, this is the annual sales of a certain sales company. In this chart, we can see the proportion of sales per month and the sales percentage for each quarter. So how do we create the double-layer doughnut chart?First select the quarterly sales data in the cell range B2:B13, click the Insert tab and click the Insert Pie or Doughnut Chart drop-down button, then choose Doughnut in the....

How to insert a chart and edit the chart data in WPS Presentation

When we use PPT for data reporting, we often insert charts to help us further illustrate.Take this PPT file as an example. So, how can we insert a chart in the slide? Click the Insert tab above, and then click Chart.In the pop-up dialog, we can select many different types of charts.The double-layered doughnut chart provides an intuitive comparison of the changes in the sales data proportion over the past two years. This video takes Doughnut as an example. Click Pie and click Doughnut. ....

Create simple and intuitive mini charts

The mini chart can help us to compare and analyze data of a row or column. It is very useful when presenting data. So in this video, we are going to show you how to create simple and intuitive mini charts.In Sheet1, we can see Monthly sales of clothing. But we can't visually tell the difference between sales each month. Therefore, we should use the mini chart.1. Click the Insert tab.2. Click the Line buttons.3. Now a Create Sparklines dialog box will pop up.4. Select cells B3:J3 as....

How to create a scatter chart in WPS Spreadsheet

A scatter chart in WPS Spreadsheet is normally called an X-Y graph. It presents all the data as points on rectangular coordinates, showing the relationships between variables. The scatter plot is a great graphical tool that we often use for statistical modelling. Take this table as an example. This is a set of height and weight data of boys and girls. If we want to observe the relationship between the two variables: height and weight, with the help of a scatter chart, how can we do tha....

Create an area chart to display data trends

Do you know how to make an ordinary line chart more special? Today we are going to show you how to make a line chart with fill effects, that is, an area chart.Take this table as an example. This is the dynamic price-earnings ratio data of a certain country over a period of time. It is difficult for us to see the difference between the data. Therefore, we need to use an area chart to show the changes in the dynamic price-earnings ratio index.1. First, we click the Insert tab.2. Click th....

How to set custom symbols and symbols shortcut key in WPS Spreadsheet

When using tables to enter data, if we often need to enter symbols, we can set shortcut keys for commonly used symbols, which can improve our work efficiency. Take this size chart as an example. We need to enter the length unit cm multiple times, so how can we get a quick input? Click the Home tab, and the Symbol drop-down button, then click More Symbol to pop up a dialog box. Click the Custom Symbols tab, and then we can see that there are many system-defined symbols, including the cm....

How to draw a column chart in WPS Spreadsheet

A Column chart can help us to visually compare data differences and is also one of the chart styles often used in work.Take this table as an example, how can we quickly compare the differences in sales of each country each country's sales? 1. Click Insert, click Chart, and click Column.2. Click the column with the mouse, and then the editing window will pop up on the right. Then, we can modify the color of the column in FILL&LINE. 3. Click SERIES. We can adjust the gap between the....