Skip to content

Module 02 · Lesson 07

Charts that make one point

The question decides the chart, not the colours.

Excel tools6 min
ChartUse it toExample
ColumnCompare a few items or months side by sideSales per month
BarCompare many items with long namesStock per item
LineShow a trend over timeWeekly sales
PieShow parts of one whole, 5 slices or fewerShare of sales by category
  1. 1

    Select. Select the labels and the numbers together (hold Ctrl to pick columns that are apart).

  2. 2

    Insert. Insert › Recommended Charts, or Alt+F1 (chart on the sheet) or F11 (chart on its own sheet).

  3. 3

    Label. Use the + button beside the chart for titles, data labels and axis titles.

Five fixes for a professional chart

  1. Sort the data: biggest at the top (Data › Sort Largest to Smallest).
  2. Say what it shows: a title that states the point, plus the unit.
  3. Label the bars: data labels on; then the gridlines can go.
  4. One colour: use a second colour only to highlight one bar.
  5. Remove clutter: no 3-D, no shadows, no legend for one series.