If you’re tired of constantly copy-pasting data from Excel into PowerPoint every time something changes, this quick guide has just what you need. Today, I’m showing you how to link your Excel data to PowerPoint charts so updates you make in Excel automatically show up in your presentation. Yes, no more manual pasting!

Why Bother Linking Excel to PowerPoint?

You may already know the struggle: you tweak your data in Excel, then spend time copying and pasting the updated numbers into PowerPoint. Then, you fix the formatting again because it inevitably got messed up during the copy-paste. It’s time-consuming and error-prone.

By linking the data, all updates happen automatically in PowerPoint once changes are made in Excel. This saves time, ensures accuracy, and helps you focus on more important things. Ready to connect Excel and PowerPoint seamlessly? Let’s jump in.

Watch the tutorial here:

Setting Up the Excel Workbook

We’re starting with a workbook for Mel’s Fruit Company sales data, spread across five worksheets—one for each quarter and one titled “Sales Data.” This “Sales Data” sheet will be the main source that links your Excel data to PowerPoint Charts. Anytime you update here, those changes will reflect in your presentation.

Tip: Remove filter dropdowns in Excel before linking to PowerPoint. Why? They won’t work in PowerPoint, and honestly, they don’t look great there either. Here’s how to do that:

  1. Click inside your table.
  2. Go to the Table Design tab.
  3. Uncheck Filter Button. The filters will disappear.

RELATED TOPIC: How to Easily Insert a YouTube Video Into PowerPoint

Moving Data from Excel to PowerPoint

Once your data is cleaned up and ready to go, select everything you need from your Excel sheet.

  1. Copy the data.
    In Excel, highlight your sales data (or whatever data you’re working with), and copy it (Ctrl + C).
  2. Switch over to PowerPoint and choose where you want the data.
  3. Under the Home tab, click on Paste > Paste Special.
  4. Select Paste Link and choose the Microsoft Excel Worksheet Object.
  5. Click OK, and PowerPoint will now automatically update when Excel changes.

Quick Formatting Fix

Once your data is pasted into PowerPoint, you might notice part of it is hard to read (like transparent text). Here’s a simple fix:

  • Select your data in PowerPoint.
  • Go to Shape Format > Shape Fill and change it to a solid background color like white.

Linking Excel Charts to PowerPoint

Let’s move on to charts. It’s the same idea: any changes you make in Excel will reflect in PowerPoint. Here’s how to create a linked chart inside PowerPoint:

Step-by-Step: Create the Chart in Excel

  1. In Excel, click anywhere inside your data.
  2. Go to Insert > Charts and choose your chart type (I like the Clustered Column chart, but feel free to pick what works for you).
  3. Do all your important formatting before copying it into PowerPoint. Things like font sizes, chart titles, and axis labels are better handled in Excel. You’ll save yourself a lot of editing later.

Step-by-Step: Paste the Chart Into PowerPoint

Once your chart looks good in Excel:

  1. Copy the chart (Ctrl + C).
  2. Head over to PowerPoint, and choose Paste Special again.
  3. This time, select Keep Source Formatting and Link Data. Your chart is now dynamic—changes made in Excel will reflect in PowerPoint.

Just like earlier with the data, you might encounter some transparency issues or missing backgrounds. To fix this:

  • Select the chart.
  • Navigate to Format > Shape Fill, then choose White (or any other background color you prefer).

RELATED TOPIC: How to Create a Pivot Table in Microsoft Excel

Updating Excel Data and Charts Dynamically in PowerPoint

Here’s where the magic happens—let’s see how data changes work across both platforms.

  • In your Excel sheet: Change any value (e.g., updating Q1 sales from $17,425 to $18,000).
  • In PowerPoint: The change will automatically reflect in the data table. If your chart doesn’t update immediately, click Chart Design > Refresh Data, and PowerPoint will sync to match Excel.

Need to reflect Quarter 2 sales data instead of Quarter 1?

  • Copy the Q2 data, paste it back into the “Sales Data” worksheet, and your PowerPoint slide will update instantly.

Small Glitch to Watch Out For

Sometimes when pasting new data, Excel might sneak those pesky filter dropdowns back in—annoying, right? If this happens, repeat the step to remove them:

  1. In Excel, select the table, and turn off filter buttons again via Table Design.
  2. To update PowerPoint, right-click the table in the slide and choose Update Link. The dropdowns should vanish.

Modifying and Updating Charts

Have you made edits in your Excel chart, but PowerPoint hasn’t caught on yet?

  • Inside PowerPoint, go to Chart Design and opt to Refresh Data. Everything should now sync beautifully.

You can also click Edit Data to go straight back to the linked Excel doc, make changes, and return to PowerPoint, which will reflect everything right away.

A Final Note: PowerPoint is a One-Way Street

Just a heads-up, PowerPoint can’t send data back to Excel. Changes only flow from Excel to PowerPoint. So, if you catch something that needs fixing, jump back into your Excel spreadsheet, update the numbers, and everything will magically update in PowerPoint. Simple as that.

RELATED TOPIC: How to Use PowerPoint Slide Master Effectively

Wrapping It Up

Linking Excel data to PowerPoint charts is a serious time-saver. Whether you’re working with massive datasets or just trying to make sure your boss has the latest figures ahead of that big presentation, this little workflow will save you from endless copy-paste agony.

Need more tips? Want to get fancy with slicers or pivot tables? Check out my other tutorials linked below!

If this helped you out, don’t forget to give the video a thumbs up and hit subscribe for more quick tips on working faster and smarter in Excel.

Get Started with Microsoft 365

Be sure to subscribe to my YouTube Channel for more Microsoft Excel and Microsoft 365 Tutorials.

This page may contain affiliate links. These are tools I personally use and love. I may receive a small commission should you make a purchase using one of these links. This helps keep the tutorials and website posts coming and up to date. Thank you for your support! For more information please see my full disclaimer.

RELATED ARTICLESMORE FROM AUTHOR