Step-by-Step: Create Your First Chart

  1. 1

    Organise your data

    Put labels in the first row or column and data in adjacent cells. Charts work best with clean, organised data. Include headers — Excel uses them as chart labels automatically.

  2. 2

    Select the data range

    Click and drag to select all the data you want to chart, including headers. Hold Ctrl to select non-adjacent ranges.

  3. 3

    Insert the chart

    Go to the Insert tab → Charts group. Click the chart type you want. For general use, Recommended Charts (Insert → Recommended Charts) shows Excel's suggestions based on your data.

  4. 4

    Choose the right chart type

    Bar/Column chart: comparing categories. Line chart: trends over time. Pie chart: proportions of a whole (use sparingly — bar charts communicate proportions more clearly). Scatter chart: relationships between two variables.

  5. 5

    Add a title

    Click on "Chart Title" in the chart and type a clear, descriptive title. A chart without a title leaves viewers guessing what they are looking at.

  6. 6

    Format the chart

    Use the Chart Design tab to change the overall style and colour scheme. Use the Format tab to format individual elements (axes, legend, data labels). Click any chart element to select and format it specifically.

  7. 7

    Add data labels if needed

    Right-click on the data series → Add Data Labels. Useful for pie charts and small bar charts where exact values matter.

Quick chart shortcutSelect your data and press Alt + F1 (Windows) or Fn + Option + F1 (Mac) to instantly create a default chart on the same sheet. Press F11 instead to create it on a new sheet.

Moving and Resizing Charts

Click and drag the chart to move it. Drag the corner handles to resize. To move a chart to its own sheet: right-click the chart → Move Chart → New Sheet.

Frequently Asked Questions

Charts in Excel update automatically when the underlying data changes — no need to recreate the chart. Just edit the cells in your data range and the chart reflects the changes immediately.
Right-click the chart → Select Data → Add. Or click the chart, then drag the blue selection handles on your data range to include the additional data.
Right-click the chart → Save as Picture. Choose your format (PNG for best quality) and save location. Alternatively, copy the chart and paste it directly into Word, PowerPoint or an email.