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
Select the table, headings included:
A1:B7. Then click Chart in the toolbar. Column is already picked, so click Insert.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.
June looks wrong, and it is: someone typed 520 for 5,200. Change
B7to 5200 and watch June's column.To let people read the exact figures, tick Data labels in the Chart panel.
Remember
- Select the data with its headings, then insert the chart.
- A first column of text becomes the categories along the axis; each heading above numbers names a series.
- The chart follows the cells: change the data and it redraws.
- Give every chart a title. Add data labels when there are few values and the exact figures matter.
Previous: GROUPBY and PIVOTBY: PivotTables as formulas · Next: Bar charts for long names