WPS Office

Free All-in-One Office Suite with PDF Editor

Read, edit, and convert PDFs with the powerful PDF toolkit.

Microsoft-like interface, easy to use.

Windows • MacOS • Linux • iOS • Android

# How to create a scatter chart in WPS Spreadsheet

Uploaded time: November 15, 2021 Difficulty Beginner

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