How to create a scatter chart in WPS Spreadsheet

Uploaded time: November 15, 2021 Difficulty Beginner

A free Office suite fully compatible with Microsoft Office

Free Download

How to create a scatter chart in WPS Spreadsheet

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 that?

Before drawing a scatter chart, we need to know exactly what the X-axis is and what the Y-axis is, rather than blindly selecting the table data. Here we first select A1:B1, press the Ctrl+Shift+downarrow to select all the data in column A and column B. Click the Insert tab, and click theInsert (X Y) Scatter Chart drop-down button. There are several types of scatter charts in the drop-down menu. Here, we just select Scatter.

In order to analyze the data more clearly, we need to set up the chart.

1. Adjust the value of coordinate axes

At this point, we can see that the data of the scatter chart is densely distributed on the right side of the chart. Double-click the X-axis, and in the AXIS OPTIONS area, click AXIS.

The data points in the chart are all in the range of 140-200. So, in the Bounds area, we input 140 in the Minimum box, and input 200 in the Maximum box.

After finishing settings, we click the Chart Element shortcut button and check Axis Title. We change the X-axis title to Weight, while changing the Y-axis title to Height.

2. Add trendline and equation

In the Chart Element area, we can also check Trendline to add a trend line to the scatter chart.

There is a small triangle on the right side of The Trendline. Click this small triangle, and choose More Options. At this point, under the TRENDLINE tab, we can check Display Equation on the chart and Display R-squared value on the chart to add equation and R-squared value to the scatter chart.

At this point, it can be seen visually that the data points on the scatter chart are densely distributed, and the two variables are positively correlated, i.e., the higher the height, the greater the corresponding weight will be. In Sheet2, I have displayed some data relationships for the scatter chart.

At this point, we have finished a simple scatter chart. Did you get it?

For all, easy your work with WPS office suite. Free download WPS Office for PC, Mobile, Windows, Mac, Android, iOS online.