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

Similar to a scatter chart, a bubble chart is mainly composed of bubbles and variables to display information. Unlike scatter charts that can only display variables in the X and Y axis, bubble charts display the skill to the third variable with bubble areas.Bubble charts can be used widely in making maps- a perfect match for displaying data with regional characteristics.This is the survey data of mobile phone sales in a certain area. Let's take it as an example to make a simple bub....

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

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Counting the amount in areas of finance and accounting is quite necessary. Take this Budgetary sheet as an example. The table's currency symbols and decimal points are badly aligned, which is not convenient for us to consult and calculate. How can we improve it? Select the cells D7-D15. Click Number Format in the Home tab, and select More Number For....

We can analyze data more intuitively with charts in daily work.Take this table as an example. We want to present the clothing sales of each state in the United States in a more direct way, so we can insert a pie chart to know the proportion quickly. First, we select the cell range of D1:E6, click the Insert tab, and click the Insert Pie or Doughnut Chart drop-down button. There're several types of pie charts. We select Pie here to insert a pie chart in the table. Select the pie cha....