Course / Charts

Your first chart

Select a table, insert a column chart, give it a title, and watch it follow the data. Beginner · 4 min · Column chart, Chart title, Data labels

A chart shows a table as a picture, so a pattern that takes a minute to read in the numbers takes a second to see.

Making one is always the same two moves: select the data, headings included, then insert the chart. The headings matter: they tell Excel what the columns are called.

A column chart compares amounts side by side. It is the one to reach for first.

In Excel, it's Insert → Charts → Column (or Recommended Charts). Here, it's the Chart button in the toolbar. A chart's title, type and options are in the Chart panel, which shows while the chart is selected. On a phone, tap the chart and then Chart settings in the toolbar to open it.

Steps

  1. Select the table, headings included: A1:B7. Then click Chart in the toolbar. Column is already picked, so click Insert.

  2. A chart without a title makes the reader guess. Click the chart to select it: the Chart panel opens on the right (on a phone, tap Chart settings in the toolbar). Under Chart title, type Sales by month and press Enter.

  3. June looks wrong, and it is: someone typed 520 for 5,200. Change B7 to 5200 and watch June's column.

  4. To let people read the exact figures, tick Data labels in the Chart panel.

Remember

Previous: GROUPBY and PIVOTBY: PivotTables as formulas · Next: Bar charts for long names