Subscriber only lesson.
Sign up to this course to view this lesson.
Working with Scatter plots
When to use
This chart type can be useful for identifying clusters and outliers
Reminder of Charting Goals
- Every chart should tell a story, quickly and effectively
- Extra chart elements create noise, and get in the way of the story
- It is a best practice to remove as much excess ink (noise) as you can
Creating a Scatter plot
- You must have data with two columns of values in order to plot in a scatter plot
- Go to Insert --> Charts -->Scatter Plot and select the Scatter Plot icon
Enhancing the Chart context
- Reformat your source data number format and it will carry through to the chart
- To link a title to a cell, select the chart title, press the equals key, click on a cell and press Enter
Enhancing the Axes
- Right click an Axis and go to Axis Options in order to change the start and end points of the axis
- Add labels to your axes by going to Chart Tools --> Design --> Add Element --> Axis Titles
Hints & tips
- Right clicking any data series will allow you to add Trend Lines to the chart
Lesson notes are only available for subscribers.