Chart Drill
Exercise 2: Make a line chart of the monthly trend
Task
Show how sales change month by month. Create a line chart.
Moves 0 (target 1)
FileHome
Chart
| Month | Sales |
| Apr | 120 |
| May | 150 |
| Jun | 90 |
| Jul | 180 |
| Aug | 160 |
| Sep | 140 |
Select the table range and create a chart from the Insert tab. Alt + F1 also creates one right away.
Show how sales change month by month. Create a line chart.
This drill is for computer screens. On a phone you can review the steps.
- Select A1:B7
- Insert > Insert Line or Area Chart > Line
Key takeaway
A line chart makes change over time easy to follow.
See Excel Charts for details.