Chart Drill
Exercise 8: Change the vertical axis minimum
Task
The changes in satisfaction look tiny. Set the vertical axis minimum to 80.
Moves 0 (target 1)
FileHome
| Month | Satisfaction |
| Apr | 86 |
| May | 88 |
| Jun | 87 |
| Jul | 91 |
| Aug | 93 |
The changes in satisfaction look tiny. Set the vertical axis minimum to 80.
This drill is for computer screens. On a phone you can review the steps.
- Click the vertical axis numbers to select the axis
- Ctrl + 1 (or right-click > Format Axis)
- Enter 80 for the Minimum bound
Key takeaway
A line chart may raise the minimum to show change. Bar charts start at 0.
See Excel Charts for details.