How to Transfer Data from Excel to PowerPoint

Tired of manually updating your PowerPoint charts every time a number changes in your Excel spreadsheet? You don't have to anymore. This guide will show you exactly how to link a data table or chart from Excel to PowerPoint, creating a dynamic connection that saves you time and prevents embarrassing errors from using old data in your presentations.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Choose Your Method: Understanding Your Options

There are two main ways to get data from Excel into your presentation, and the right choice depends on whether you need it to be updated automatically. One is a simple, static copy-paste, while the other creates a live link to your original spreadsheet. We’ll cover both.

Method 1: The Simple Copy & Paste (The Static Approach)

This is the method everyone knows. You highlight the cells or the chart in Excel, press Ctrl+C (or Cmd+C on Mac), click into your PowerPoint slide, and press Ctrl+V (or Cmd+V).

When to use this:

• You need a quick, one-time snapshot of the data.
• The data in your spreadsheet is final and will not change.
• You're sending the PowerPoint to someone who won't have access to the original Excel file.

The biggest downside is that this is a static copy. If the data in your original Excel file changes, your PowerPoint presentation will not update. You’ll have to remember to repeat the copy-paste process every time there’s an update, which is a recipe for showing outdated information without realizing it.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 2: Creating a Live Link (The Dynamic Approach)

Linking is the secret to building presentations that always reflect the latest data. When you link your Excel file to your PowerPoint slide, you are telling PowerPoint to "look at" the original Excel file for its information. When the spreadsheet is updated, all it takes is a quick refresh to see those changes in your presentation.

This is the best method for recurring reports, dashboards, and presentations where data accuracy is essential.

How to Link Excel Data Tables to PowerPoint (Step-by-Step)

Let's walk through the exact steps to create a live connection for a data table or range of cells. This method basically embeds a small, viewable portion of your spreadsheet directly onto your slide.

1. First, open both your Excel workbook and your PowerPoint presentation. Side-by-side works best. In your Excel sheet, highlight the group of cells you want to show in your presentation. Copy it by right-clicking and selecting “Copy” or using Ctrl+C.
2. Navigate to your PowerPoint slide. Instead of just pasting, click the small arrow below the “Paste” button on the Home ribbon. A dropdown menu will appear. Select “Paste Special.”
3. In the Paste Special dialog box, choose “Paste link.” You must select the "Paste link" radio button on the left. If you don't, you will just be pasting static data. On the right, select "Microsoft Excel Worksheet Object" from the list. This tells PowerPoint you're linking to an actual Excel object.
4. Click OK. Your Excel data will now appear on your PowerPoint slide! It might appear as a simple table, and you can resize it as needed. What you’ve done is create a visual link back to your A1:D10 (or whatever your range was) in the source Excel file.

Now, try changing a value in your original Excel sheet and remember to save the file. Go back to your PowerPoint slide. The data won't update instantly - we’ll cover that next - but the connection is now live.

How to Link Excel Charts to PowerPoint (Step-by-Step)

The process for linking a chart is very similar but with slightly different, more intuitive paste options. Linked charts are incredibly powerful for making your slides more visual and digestible.

1. In Excel, click once on the chart you want to use to select it. Copy the chart using Ctrl+C (or Cmd+C).
2. Go to your PowerPoint slide. Instead of hitting paste immediately, right-click where you want the chart to go, or click the dropdown menu under the “Paste” button. You’ll see several “Paste Options.”
3. Choose One of the "Link Data" Options. You'll generally see two options that create a link. They're usually the third and fourth icons:

You can hover over each icon for a live preview of how the chart will look before you click.

1. Position and resize the chart as needed. Your chart is now dynamically linked. If you go back to Excel and change the data feeding the chart (for instance, updating last month's sales numbers), the changes will be reflected in PowerPoint after a quick refresh.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Keep it Fresh: Managing and Updating Your Linked Data

Once you’ve linked your data or charts, you have control over how and when they update. This avoids unexpected changes while you’re mid-presentation.

How PowerPoint Checks for Updates

Whenever you open a PowerPoint file that contains linked objects, you'll usually get a security notice asking if you want to update the links. Clicking "Update Links" will tell PowerPoint to immediately check all the linked Excel files and pull in the latest information. If you're not ready to do that, you can click "Cancel," and the presentation will keep showing the data as it was when it was last saved.

Manually Refreshing Your Links

What if you have both files open and want to force an update without closing and re-opening your presentation? You can do that manually.

1. Go to File > Info.
2. On the bottom right of the screen, you will see a section called “Related Documents.” Click the link that says “Edit Links to Files.”
3. A new dialog box will appear, listing all the files linked to your presentation. Select the link you want to refresh and click “Update Now.”
4. You can also use this menu to “Break Link” if you ever want to make your chart or table static.

Common Issues and Quick Troubleshooting Tips

Linking is extremely reliable, but a few common things can trip you up. Here’s what to look out for.

Fixing Broken Links

The most common problem is a "broken link," which almost always happens if the source Excel file is moved to a new folder or renamed. PowerPoint is still looking for it at the old location.

• The Fix: Go to the File > Info > Edit Links to Files menu. Select the link that has an error, click the “Change Source...” button, and navigate to the new location of your Excel file to repair the connection.

Best Practices for File Management

To avoid broken links in the first place, try to keep your presentation and the source spreadsheet in the same folder. This is especially important if you're going to zip the files and send them to a colleague. Better yet, store both files in a shared cloud folder like OneDrive or a SharePoint site. This keeps the file paths stable for everyone on your team.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Formatting Best Practices

Generally, you should finalize as much formatting as possible - like cell colors, number formats, and bolding - in Excel before linking. While you can make minor tweaks to resizing and alignment in PowerPoint, these can sometimes be overwritten when the link is updated. Make formatting changes in the source (Excel) to ensure they stick.

Final Thoughts

Linking data and charts from Excel to PowerPoint moves you from manual grunt work to building automated reports. By using the "Paste Special" with a link, your presentations become dynamic assets that reflect real-time business performance, ensuring you're always sharing accurate, up-to-date information without last-minute scrambling.

When you're pulling data from a single spreadsheet, linking works perfectly. But we know business data is rarely that simple. Often, you first have to pull reports from Google Analytics, Salesforce, HubSpot, and other apps just to get the data into Excel in the first place. That’s the manual process we’re built to eliminate. With Graphed, you can connect directly to your data sources and create live, interactive dashboards just by asking for what you need in plain English. No more exporting CSVs or wrestling with linking - just answers.