Chart Drill
Exercise 1: Make a column chart of branch sales
Task
Compare sales by branch. Select the whole table and create a clustered column chart.
Moves 0 (target 1)
FileHome
Chart
| Branch | Sales |
| New York | 520 |
| Chicago | 380 |
| Houston | 260 |
| Seattle | 210 |
Select the table range and create a chart from the Insert tab. Alt + F1 also creates one right away.
Compare sales by branch. Select the whole table and create a clustered column chart.
This drill is for computer screens. On a phone you can review the steps.
- Select A1:B5 (or press Ctrl + A inside the table)
- Insert > Insert Column or Bar Chart > Clustered Column, or Alt + F1
Key takeaway
Alt + F1 instantly creates the default chart (clustered column) on the same sheet.
See Excel Charts for details.