Subscriber only lesson.
Sign up to this course to view this lesson.
About this lesson
When you need to show values of a different scale, there is no better way than to add an additional axis.
Download this lesson’s related exercise files.Plotting data using the secondary axis.xlsx
58.4 KB Plotting data using the secondary axis - Completed.xlsx
Plotting Data Using The Secondary Axis
Adding a secondary axis to plot values of different scales.
When to use
Use when you have values of very different scales so that they can be compared in a single chart.
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 the Combination Chart
- Select your data
- Create your multi series chart as desired
Adding the secondary axis
- Right click the series you want plotted on the secondary axis
- Choose Format Data Series --> Series Options --> Plot Series On --> Secondary Axis
- Expand the chart so that all rows are readable
- To link a title to a cell, select the chart title, press the equals key, click on a cell and press Enter
- Other modifications can be made as with any normal chart
Hints & tips
- Remove items and elements that you don’t need by selecting them and pressing the Delete key
- CAUTION: Removing either the primary or secondary axis for the chart will cause all data to be plotted on the primary axis
- Change font sizes by selecting an element and formatting it from the Home tab
- When removing gridlines, make sure you are selecting the gridlines and not the entire chart
Lesson notes are only available for subscribers.