How to Change Excel Data Source in PowerPoint Chart

There's nothing more frustrating than pasting an Excel chart into PowerPoint, only to realize the data source is wrong or needs an update. Facing the prospect of deleting it and starting over feels like a waste of time. Luckily, you don't have to rebuild your chart. This tutorial will walk you through how to change the underlying Excel data source for any chart directly within PowerPoint, whether you need to point to a new range of cells, a different tab, or a completely separate file.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Does PowerPoint Need an Excel Data Source?

When you create or paste a chart into PowerPoint from Excel, it maintains a connection to a spreadsheet where the numbers reside. This connection can work in two primary ways: either it can be embedded or linked. Understanding the difference is crucial for managing your presentations effectively.

Embedded Data

When a chart's data is embedded, PowerPoint creates a self-contained, lightweight Excel worksheet that exists entirely inside your presentation file (.pptx). Think of it like taking a photo and gluing it into a scrapbook, the photo is now part of the book itself.

• Pros: This method is highly portable. You can email the PowerPoint file to anyone, and they'll be able to open and view the chart without needing access to any external spreadsheet. Everything is neatly packaged in one place.
• Cons: The data is disconnected from its original source. If you update the master Excel file you used to create the chart, the chart in your presentation will not automatically update. It's a static snapshot.

Linked Data

When data is linked, your PowerPoint chart remains connected to a separate, external Excel file saved somewhere on your computer or a shared drive. This is like placing a shortcut to a photo file in a document. The document doesn't contain the photo itself, but it knows where to find it.

• Pros: This is perfect for dynamic reports. When you update the numbers in the external Excel file, you can easily refresh the chart in PowerPoint to reflect the latest data. It keeps your presentation current without manual re-entry.
• Cons: If you move, rename, or delete the source Excel file, the link will break, and your chart won't be able to update. When sharing the presentation, you need to ensure the recipient also has access to the linked Excel file.

Most of the methods below will work for both embedded and linked charts, but changing the source file itself is a process specifically for linked charts.

The “Edit Data” Command: Your Go-To Method

For most day-to-day tweaks, the "Edit Data" command is the quickest and easiest way to access and modify your chart's underlying spreadsheet.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Select Your Chart in PowerPoint

First, click once on the chart you want to modify. You'll know it's selected when you see a border with handles appear around the chart's perimeter. This action causes the contextual "Chart Design" and "Format" tabs to appear in the PowerPoint ribbon at the top of your screen.

Step 2: Access the Chart Design Tools

With your chart selected, click on the Chart Design tab. This tab contains all the tools related to the style, layout, and, most importantly, the data of your chart.

Step 3: Open the “Edit Data” Menu

In the "Data" group on the right side of the Chart Design ribbon, you'll find a button labeled Edit Data. Clicking this will give you one or two options, depending on how your chart was created:

• Edit Data: This opens a small Excel window directly on top of your PowerPoint slide. It displays the embedded worksheet and is ideal for quick value changes, adding a new row of data, or making simple adjustments to the data range.
• Edit Data in Excel: This opens the full Microsoft Excel application with the source spreadsheet loaded. This is the option you need for more complex tasks like switching to a different worksheet or linking to a completely new file.

How to Change the Data Source Range, Sheet, or File

Once you understand how to access the underlying data, you can tackle several common scenarios for changing the source.

Scenario 1: Using a Different Data Range in the Same Worksheet

This is the most common use case. For example, maybe your spreadsheet has data for all twelve months, but your chart is only showing the first six. Here’s how to expand the range.

1. Select your chart in PowerPoint.
2. Go to the Chart Design tab and click on Edit Data in Excel.
3. The source Excel spreadsheet will open. You’ll immediately see a colored outline (usually blue) around the cells currently being used by the chart.
4. Simply hover your mouse over the small square handle at the corner of this blue outline. Your cursor will change to a diagonal double-headed arrow.
5. Click and drag this handle to expand or shrink the data range to include the new cells you want to plot. As you drag, you'll see the chart in PowerPoint update in real time.
6. Once you're satisfied with the new range, save the Excel file (if prompted) and close it. Your PowerPoint chart is now updated.

Scenario 2: Using a Different Worksheet in the Same Excel File

Let's say your Excel file has monthly sales data on "Sheet1" and quarterly sales data on "Sheet2". If your chart is currently pulling from Sheet1, here’s how to switch it to Sheet2 without starting over.

1. Select your chart in PowerPoint and go to Chart Design > Edit Data in Excel.
2. Once your source file is open in Excel, make sure the chart data is selected. If not, click on the data displayed in the worksheet. You should now see the Excel-specific Chart Design tab.
3. On this tab, click the Select Data button. This will open the "Select Data Source" dialog box.
4. The dialog box contains a field called "Chart data range." This field shows the formula describing the current source (e.g., =Sheet1!$A$1:$B$7). You can either manually edit this formula or click the grid icon next to it.
5. Now, without closing the dialog box, simply click on the tab for the other worksheet (e.g., "Sheet2").
6. Select your new data range on Sheet2 by clicking and dragging. You'll see the "Chart data range" field update automatically to reflect your new selection (e.g., =Sheet2!$A$1:$C$5).
7. Click OK. The chart data will be repopulated, and the chart in PowerPoint will instantly reflect changes. You can now save and close the Excel file.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Scenario 3: Linking to a Completely Different Excel File

This situation arises when your chart is linked to an external file (e.g., Sales_Q1.xlsx), but now you need it to pull data from a different file altogether (e.g., Sales_Q2.xlsx). This advanced operation is handled through PowerPoint's link manager, not the "Edit Data" command.

Step 1: Locate the File Link Information

First, you need to find where PowerPoint manages its external file links.

1. In PowerPoint, click the File tab in the upper-left corner.
2. Select Info from the menu on the left.
3. On the bottom right side of the screen, look for a section labeled "Related Documents." Below that, you will find an option to Edit Links to Files. Click it. (Note: A link for this option will show even if you do not have any external links).

Step 2: Use the "Change Source" Feature

Clicking Edit Links to Files opens the Links dialog box. This window lists all the external files your presentation is currently linked to, a feature especially handy for larger files. We have 3 main options here:

• Update a changed link or restore broken ones by clicking on Update now
• Open the original source location with the Change Location... button.
• Replace it with a new one using Break Link.

Step 3: Select Your New Excel File and Confirm

A file browser window will appear where you can select a completely different Excel spreadsheet.

• Navigate to your new source file (e.g., Sales_Q2.xlsx).
• Once ready, click Open and then Close to return to your presentation.

PowerPoint will now point the chart to the new file. As long as the data in the new spreadsheet is structured similarly to the old one (i.e., the same columns and a similar number of rows), your chart should update perfectly. If the structure is very different, you may need to use the "Select Data" method from Scenario 2 to fine-tune the range.

Troubleshooting Common Issues

Sometimes things don't go as planned. Here are a few common hiccups and how to fix them.

The "Edit Data" Button is Grayed Out

If you select your chart but the "Edit Data" button is grayed out, it usually means one of two things:

• The 'chart' is actually a picture. Someone may have copied it from Excel and used "Paste as Picture." Unfortunately, you cannot edit the data for an image. You'll have to find the source and re-paste it as a proper chart.
• It's a specific object type, like a SmartArt graphic, that doesn't use a standard Excel data source.

Solution: The best way to avoid this is to always paste charts using one of the first few paste options, typically "Use Destination Theme & Link Data" or "Keep Source Formatting & Embed Workbook."

My Chart Isn't Updating Automatically

If you've edited a linked Excel file but the chart in PowerPoint hasn't changed, the link might be set to manual update.

Solution: Go to File > Info > Edit Links to Files. In the dialog box, select your link and ensure you have selected "Automatic" for the update. As a short-term solution, you can use Update Now to manually refresh and display the latest information in your charts instantly.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

My Chart Looks Broken After Changing the Data Source

If PowerPoint has automatically assumed the data types assigned in your Excel sheet, and these do not match the selected model of a chart, it will result in a 'broken' appearance.

A common example can be seen in a chart where some labels are considered to be independent lines of text, rather than the X-axis for your bar or other line representation. This gives an impression of a "broken" chart.

Solution: Once you change the link to different data, use the Edit your Chart Data Option to correct the data type selection. Right-click on the chart to bring up a menu option to change the format to the desired representation as well as colors of the chosen scheme.

Final Thoughts

Managing data sources between Excel and PowerPoint doesn’t have to be a chore. Now you can confidently change your chart's underlying data, whether it involves adjusting a cell range, switching to a different worksheet, or re-linking to an entirely new file, all without losing your formatting or starting from scratch.

While these built-in tools are powerful, manually keeping track of linked files and updating reports can get cumbersome, especially when information for your marketing or sales data is scattered across multiple SaaS platforms like Google Analytics, Shopify, Facebook ads, or HubSpot rather than one Excel. We created Graphed to solve exactly this type of problem. Everything becomes so much easier and simpler when data is in one single place. Once you connect all your sources in Graphed, there is no more need to jump between multiple dashboards to create visuals. A feature allowing chat interaction and AI completion allows you to get all types of data representation in a matter of seconds. As an AI-powered data assistant for reporting and data analysis, it is always up-to-date.