How to Insert a Chart in PowerPoint (and Edit the Numbers)
A chart says in one glance what a table of numbers takes a minute to explain. PowerPoint has Excel's charting engine built in, so you can make one without leaving the slide — and if the numbers already live in Excel, you can paste a chart that updates when the spreadsheet does.
Quick reference
| What you want | How |
|---|---|
| Insert a chart | Insert → Chart (or the chart icon in a content box) |
| Change the numbers | Select the chart → Chart Design → Edit Data |
| Change the type | Chart Design → Change Chart Type |
| Add or remove titles, labels, legend | Click the + next to the chart |
| Paste from Excel, linked | Copy in Excel → Paste Options → Keep Source Formatting & Link Data |
1. Insert a chart
1. Go to Insert → Chart, or click the chart icon in an empty content box.
2. Pick a type. Column for comparing amounts, Line for change over time, Pie for parts of a whole (keep it to five slices or fewer), Bar when the labels are long.
3. Click OK. A small spreadsheet opens with sample data.
2. Pick a type. Column for comparing amounts, Line for change over time, Pie for parts of a whole (keep it to five slices or fewer), Bar when the labels are long.
3. Click OK. A small spreadsheet opens with sample data.
2. Type your own numbers
Replace the sample data in the little spreadsheet. The chart updates as you type. Drag the blue corner of the range to include more or fewer rows and columns. Close the spreadsheet when you're done — the data is saved inside the slide.
To get back to it later, click the chart → Chart Design → Edit Data.
3. Tidy it up
Click the chart and three buttons appear on the right:
• + (Chart Elements) — tick or untick the title, axis titles, data labels, gridlines and legend.
• Paintbrush (Chart Styles) — pick a style and a colour set.
• Funnel (Chart Filters) — hide a series or category without deleting it.
• Paintbrush (Chart Styles) — pick a style and a colour set.
• Funnel (Chart Filters) — hide a series or category without deleting it.
Delete the gridlines and add data labels and most charts immediately look cleaner.
4. Change the chart type
Picked a pie and wish it was a bar? Chart Design → Change Chart Type. The numbers stay.
5. Paste a chart from Excel
Copy the chart in Excel, then paste in PowerPoint. Click the paste options icon that appears and choose:
• Use Destination Theme & Link Data — matches your slide colours and updates when the Excel file changes.
• Keep Source Formatting & Embed Workbook — looks exactly as it did in Excel and carries its own copy of the data.
• Picture — a static image. Smallest file, can't be edited.
• Keep Source Formatting & Embed Workbook — looks exactly as it did in Excel and carries its own copy of the data.
• Picture — a static image. Smallest file, can't be edited.
Linked charts refresh with Chart Design → Refresh Data.
6. Make it readable from the back
Click the chart and press Ctrl + ] a few times to enlarge all the text. Aim for nothing smaller than 18 point on a slide.
Troubleshooting
Edit Data opens a blank spreadsheet. The chart was pasted from Excel as linked and the original file has moved. Use Chart Design → Edit Data → Edit Data in Excel and point it at the file, or paste again as embedded.
The colours don't match my slides. Right-click the chart → Reset to Match Style, or choose Use Destination Theme when pasting.
The chart is squashed. Drag a corner handle, not a side one, and tick a style with a smaller legend.
Wrapping up
Insert → Chart, type your numbers, use the + to tidy. If the data lives in Excel, paste it linked and it stays up to date. Big text, few colours, no gridlines — that's a chart people can read from the back of the room.
