Chart Drill
Exercise 7: Plot YoY as a line on a secondary axis
Task
Put sales (dollars) and YoY (%) in one chart. Make YoY a line and plot it on the secondary axis.
Moves 0 (target 1)
FileHome
| Month | Sales | YoY (%) |
| Apr | 120 | 98 |
| May | 150 | 112 |
| Jun | 90 | 87 |
| Jul | 180 | 125 |
Put sales (dollars) and YoY (%) in one chart. Make YoY a line and plot it on the secondary axis.
This drill is for computer screens. On a phone you can review the steps.
- Right-click the chart > Change Chart Type
- Choose Combo in the list on the left
- Set YoY to Line, check Secondary Axis, and click OK
Key takeaway
For values with different units, a secondary axis on the right shows both changes.
See Excel Charts for details.