Chart Drill
Exercise 3: Make a pie chart of the share
Task
Show each item's share of sales. Create a pie chart.
Moves 0 (target 1)
FileHome
Chart
| Item | Sales |
| Notebook | 45 |
| Pen | 25 |
| File | 20 |
| Other | 10 |
Select the table range and create a chart from the Insert tab. Alt + F1 also creates one right away.
Show each item's share of sales. Create a pie chart.
This drill is for computer screens. On a phone you can review the steps.
- Select A1:B5
- Insert > Insert Pie or Doughnut Chart > Pie
Key takeaway
Pie charts work best with five items or fewer. Use a bar chart for more.
See Excel Charts for details.