Scatter charts show the relationships among the numeric values in several data series, or plot two groups of numbers as one series of XY coordinates. Scatter charts have the following chart subtypes:
Scatter with only markers and scatter with line and markers
Open the Scatter Chart Template from the Chart library. Drag the shape from library to start your XY charts.
Edit Scatter Chart Data
Double click the value text above point to edit the chart data, the line point position changes according to the rate of its point value and axis max value.
Note: In XY chart, you cannot edit the value text. You need to drag the yellow diamond handle to move the point position.
Change Line Marker Style
Select a series of sub shape > Click the floating action button to change its point style.
Note: In XY chart, click Change Marker Style on chart action menu to change the marker style.
Change the Interval Between Line Points (category)
Select the chart > Horizontally move the yellow diamond handle on bottom of the second point (category).
Note: This operation is not available in XY chart.
Show/Hide Connect Line Between Points
Select a series of sub shape > Click the floating action button to change its point style. This operation is not available in XY chart.
Add a Category
Click Add a Category on chart action menu.
Delete a Category
Click Delete a Category on chart action menu, you can also select the category sub shape and press - Delete key to delete it.
Set Category Number
Click Set Category Number on chart action menu, the minimum value is 1.
Set Series Number
Click Set Series Number on chart action menu, the minimum value is 1.
Set Axis Max Value
Click Set Max Value on chart action menu to set the axis max value.
Hide/Show Value Text
Click Hide/Show Value on chart action menu.
Change the Position of Value Text
Click Value Text Options on chart action menu, on Shape Data dialog click Text Position to choose the text position. This is not available in stacked and 100% stacked bar chart.
Set Value Precision
Click Precision on chart action menu to set the precision of column value and axis value.
Click Hide/Show Axis on chart action menu.
Click Hide/Show Legend on chart action menu.
Select legend sub shape > Move it to the position you want.
Share the Scatter Chart
When you complete the line chart, you can save it as the project file for revision later. You can print it or export it as the html, pdf, svg, transparent png format. You can also export it to MS Word, Excel or PowerPoint with one click.Tweet