Module 02 · Lesson 07
Charts that make one point
The question decides the chart, not the colours.
Excel tools6 min
| Chart | Use it to | Example |
|---|---|---|
| Column | Compare a few items or months side by side | Sales per month |
| Bar | Compare many items with long names | Stock per item |
| Line | Show a trend over time | Weekly sales |
| Pie | Show parts of one whole, 5 slices or fewer | Share of sales by category |
- 1
Select. Select the labels and the numbers together (hold Ctrl to pick columns that are apart).
- 2
Insert. Insert › Recommended Charts, or Alt+F1 (chart on the sheet) or F11 (chart on its own sheet).
- 3
Label. Use the + button beside the chart for titles, data labels and axis titles.
Five fixes for a professional chart
- Sort the data: biggest at the top (Data › Sort Largest to Smallest).
- Say what it shows: a title that states the point, plus the unit.
- Label the bars: data labels on; then the gridlines can go.
- One colour: use a second colour only to highlight one bar.
- Remove clutter: no 3-D, no shadows, no legend for one series.