A good chart makes a point instantly — sales going up, which product sells best, where the money goes. Excel can build one from your data in a few clicks.
Step 1: Set out your data
Charts work best with a simple table:
- Labels down the first column (for example, months or product names).
- Headings across the top row (for example, “Sales”, or “2025” and “2026”).
- Numbers in the rest.
| Month | Sales |
|---|---|
| Jan | 1,200 |
| Feb | 1,450 |
| Mar | 1,800 |
Step 2: Insert a chart
- Select your data, including the headings.
- Go to Insert > Recommended Charts.
- Excel suggests charts that suit your data. Click through them on the left to preview.
- Choose one and click OK.
Even faster: select your data and press Alt + F1 to drop a chart straight onto the sheet, or F11 to put it on a new sheet of its own.
Which chart should I use?
| Chart | Best for | Example |
|---|---|---|
| Column / Bar | Comparing things | Sales by product |
| Line | Change over time | Monthly website visitors |
| Pie / Doughnut | Parts of a whole (keep it to a few slices) | Budget breakdown |
| Scatter | Relationship between two numbers | Temperature vs ice cream sales |
When in doubt, a column chart is almost always clear.
Step 3: Add titles and labels
Click the chart. Three small buttons appear to its right:
- + (Chart Elements) — tick Chart Title, Data Labels (numbers on the bars), Axis Titles and Legend.
- Brush (Chart Styles) — change the style and colours.
- Funnel (Chart Filters) — hide some categories or series without deleting data.
Click the chart title to type your own. A title that says what the chart shows (“Sales grew 50% in Q1”) works better than one that just says “Sales”.
Chart the wrong way round?
If Excel has put months in the legend and products along the bottom (or vice versa), click the chart and go to Chart Design > Switch Row/Column.
Change the chart type
Click the chart, then Chart Design > Change Chart Type. Your data and titles stay the same.
Add more data later
Click the chart — coloured boxes appear around the data it uses. Drag the corner of the box to include new rows.
Tip: If your data is formatted as a table (Ctrl + T) before you create the chart, new rows are added to the chart automatically.
Move and resize
- Resize: drag the corner handles.
- Move: drag the chart by its border.
- Put it on its own sheet: Chart Design > Move Chart > New sheet.
- Copy into Word or PowerPoint: click the chart border, Ctrl + C, then Ctrl + V in your document.
Troubleshooting
The chart is blank or has weird numbers. Your numbers may be stored as text. Look for green triangles in the cells and convert them to numbers.
A year shows up as a line instead of a label. Excel thinks years like 2025 are numbers to plot. Type the heading cell as text (for example, add an apostrophe: '2025), or use Chart Design > Select Data to fix it.
Wrapping up
Select your data, Insert > Recommended Charts, then use the + button to add a title and labels. Keep it simple and let the chart make one clear point.
