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....

Use WPSArt to insert an organization chart with one click

Sometimes we need to draw an organization chart of the company in a document to show the relationship between different departments. With the WPSArt feature, we can quickly generate professional organization charts. Click the Insert tab and the WPSArt button to pop up the Choose A WPSArt Graphic dialog. Here, we can see the different types of graphics. Click the graphic, and the corresponding application scenario description will be displayed on the right side.Select the first organiza....

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 insert a chart and edit the chart data

When we organize the data of the document, we usually insert a chart for a supplementary explanation.Take this document as an example. The table in the document represents the annual sales volume of different regions. Now, let's look at the data comparison more intuitively by inserting a bar chart. Go to the Insert tab and click the Chart button. In the pop-up dialog, we can choose a variety of chart types. Click Bar and Stacked Bar, then a default style stacked bar is inserted int....

Use pivot chart to create a dynamic chart

A pivot chart is a graphical representation of a pivot table, which can clearly and intuitively visualize the data. Suppose we now want to create a pivot chart of the total sales of each branch in the fourth quarter. How can we do that? Take this table as an example. Select any cell in the data area, click the Insert tab, then the PivotChart button. Now select New Worksheet in the popup dialog box, and click OK. After that, we can create an empty PivotTable and an empty PivotChart.In W....

Make a ranking bar chart

The bar charts use bars with the same width to indicate the amount of data. Therefore, we can compare data intuitively. By using a bar chart, it will be convenient for us to compare the differences between data.Take this table as an example. This is the data of cumulative confirmed COVID-19 cases on April 9, 2020. If we want to see the difference in confirmed cases between countries more intuitively, we can use a bar chart.1. Click any cell in the data area.2. Click the Insert tab.3. T....

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....

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....