Course contents · Charts

Formatting a chart

Open the practice in the trainer →

When a chart is selected two contextual tabs appear: Chart Design (type, data, style, layout) and Format (colours, outlines). Next to the chart are the + (elements), brush (style) and filter buttons.

Titlesays what is shown: "Sales by quarter, thousand units", not "Chart 1"
Legendneeded with two or more series; at the bottom it saves width
Data labelsexact values on the bars; do not overload — for 30 points tooltips and axes are enough
Axis titlesunits: "$ thousand", "units"
Switch Row/ColumnChart Design → Switch Row/Column swaps series and categories: "quarters by product" ↔ "products by quarter"
Stackedthe series bars sit on top of each other — you see both the parts and the total

A secondary axis (Format Series → Secondary Axis) lets one chart show measures of different scale, but readers easily confuse which axis a line belongs to. Two charts side by side are safer.

Chart tasks

  1. Build a column chart of A1:D5 with the legend at the bottom.
  2. Give the chart the title "Sales by quarter".
  3. Switch rows and columns: make the products the categories and the quarters the series.
  4. Make it a stacked column chart and turn on data labels — each column shows its total.
  5. Title the value axis: thousand units.

Solve the tasks in the trainer →

Check yourself

  1. What does Switch Row/Column do?
  2. What is risky about a secondary axis?