To insert an Excel chart in PowerPoint, click the chart in Excel and press Ctrl + C. In PowerPoint, press Ctrl + V, then pick a Paste Options button. Choose a Link Data option if you want the chart to update when the workbook changes. Choose Embed Workbook if you want a copy that stays as it is. To refresh a linked chart, click it and choose Chart Design, Refresh Data.
The steps below are for PowerPoint for Microsoft 365 on Windows. Mac notes are near the end.
Which paste option should you pick?
When you paste a chart, PowerPoint shows five small buttons. Each one makes a different kind of chart.
| Paste option | Updates when Excel changes? | Looks like | File size | Best for |
|---|---|---|---|---|
| Use Destination Theme and Embed Workbook | No | Your deck’s colours and fonts | Larger | A final chart you may still tweak |
| Keep Source Formatting and Embed Workbook | No | Exactly as in Excel | Larger | A chart styled in Excel that must not change |
| Use Destination Theme and Link Data | Yes, when you refresh | Your deck’s colours and fonts | Small | Monthly decks with a house style |
| Keep Source Formatting and Link Data | Yes, when you refresh | Exactly as in Excel | Small | Monthly decks where Excel sets the look |
| Picture | No | A flat image | Small | Sending a deck outside, with no data inside |
Embed means the deck carries its own copy of the workbook. Link means the deck stores the path to the workbook and reads it again when you refresh.
How to insert an Excel chart that updates
- Save the Excel workbook. A link needs a saved file to point at.
- In Excel, click the edge of the chart so the whole chart is selected.
- Press Ctrl + C.
- In PowerPoint, click the slide and press Ctrl + V.
- Click the Paste Options button at the corner of the chart and choose Use Destination Theme and Link Data.
- Resize the chart on the slide. Fonts scale with it, so check they stay readable.
- Next month, update the workbook, open the deck, click the chart and choose Chart Design, Refresh Data.
You can manage all links in one place too. Save the deck, go to File, Info, then Edit Links to Files. From there you can update every link, point a link at a new file with Change Source, or tick Automatic Update.
How to insert an Excel chart that never changes
Sometimes you want the opposite. A signed off chart for an annual report shouldn’t move when someone edits the model.
- Copy the chart in Excel with Ctrl + C.
- Paste it in PowerPoint with Ctrl + V.
- Choose Keep Source Formatting and Embed Workbook, or Picture if nobody should edit it.
An embedded chart can still be edited. Click it, then Chart Design, Edit Data. The copy inside the deck opens in Excel. Your changes stay in the deck and never reach the original file.
Watch the size. An embedded chart carries the whole workbook, not only the chart’s data. Three charts from a 10 MB model can add about 30 MB to the deck.
Can you build the chart in PowerPoint instead?
Yes. Go to Insert, Chart, pick a type and click OK. PowerPoint opens a small sheet with sample data. Paste your figures into it and close it.
This chart lives entirely in the deck. It looks native and it’s easy to restyle. But it has no link to your real workbook, so every update means pasting the numbers again.
Why does a linked chart stop updating?
A linked chart stores the exact path to the workbook. These are the usual reasons it goes stale:
- The file moved or was renamed. Fix it with Change Source in Edit Links to Files.
- The workbook sits in OneDrive or Teams. The link can point at your own synced folder, which a colleague doesn’t have.
- Someone clicked Cancel on the security notice that asks to update links when the deck opens.
- The chart range didn’t grow. If you add a new month below the old data, the chart may not include it. Use an Excel table as the chart’s source so the range grows on its own.
Our guide to why Excel links break in PowerPoint has a fix for each cause.
What’s different on a Mac?
Copy and paste works the same way, and the Paste Options button offers embed, link and picture choices. Menus vary between versions, so look for Paste Special under Edit if the button doesn’t appear. Test a linked chart by moving the deck to another Mac before you rely on it.
When you refresh the same charts every month
Paste Link is fine for two or three charts in a deck you own. It gets fragile with twenty charts, shared folders and several people.
INSYNCR is a PowerPoint add in that links native PowerPoint charts straight to your data. You insert a normal chart, style it, then map it to an Excel range or a database query. You tick Automatically adjust rows so a new month adds a new bar. One click on Refresh updates every chart, table and number in the deck.
In the video, a chart is linked to regional figures and keeps the formatting it already had. Then one number changes in Excel, and one refresh updates the chart and a table together.
It runs on Windows with PowerPoint 2016 or later, and Excel is in every plan. It isn’t for Mac or PowerPoint online. Start the trial: 7 days, full access, no credit card.
The exact clicks are in linking PowerPoint charts to data. For tables, see the best tools to link Excel to PowerPoint. For every other way to bring Excel in, read how to insert Excel into PowerPoint, and compare plans on the pricing page.
Frequently asked questions
How do I link an Excel chart to PowerPoint so it updates automatically?
Paste the chart with a Link Data option, then open File, Info, Edit Links to Files and tick Automatic Update. The chart then refreshes when the deck opens, as long as the workbook is still at the same path.
Why does my pasted Excel chart look different in PowerPoint?
You probably picked a Use Destination Theme option, which swaps Excel’s colours and fonts for the deck’s. Paste again with Keep Source Formatting if you want the Excel look.
Can I edit the data of a chart I pasted from Excel?
Yes. Click the chart and choose Chart Design, Edit Data. A linked chart opens the original workbook. An embedded chart opens the copy stored in the deck.
Why didn’t my linked chart pick up the new month?
The chart reads a fixed range, and the new row sits outside it. Turn the data into an Excel table with Ctrl + T before you build the chart, and the range will grow as you add rows.

