How to create a scatter chart in WPS Spreadsheet

Uploaded time: November 15, 2021 Difficulty: Primary

How to create a scatter chart in WPS Spreadsheet

How to create a scatter chart in WPS Spreadsheet

Tips: After starting to play, you can adjust the video clarity, click

Quality

Auto 720p

Graphic skills

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.

_1.gif

 

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+down arrow to select all the data in column A and column B. Click the Insert tab, and click the Insert (X Y) Scatter Chart drop-down button. There are several types of scatter charts in the drop-down menu. Here, we just select Scatter.

_2.gif

 

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.

_3.gif

 

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.

_4.gif

 

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.

_5.gif

 

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.