How to Link a Chart from Excel to Word

Creating a report that uses charts from an Excel spreadsheet is a classic part of business life. The problem starts when the data in your spreadsheet changes. You’re now stuck in a cycle of deleting the old chart in your Word document, navigating back to Excel, re-copying the new one, and pasting it back in - over and over again. It’s a tedious task that wastes time and opens the door for errors.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Instead of manually copy-pasting, you can create a direct link between your Excel chart and your Word document. This short tutorial will walk you through exactly how to do it, so your reports can update automatically and you can get back to more important work.

Why Should You Link an Excel Chart to Word?

You’ve probably been copying and pasting objects between Microsoft Office apps for years, so you might wonder what’s so special about linking. Let’s break down the difference between the two main methods: embedding vs. linking.

Traditional Pasting (Embedding)

When you copy a chart from Excel (using Ctrl+C or right-click > Copy) and paste it into Word (Ctrl+V), you are embedding it. Think of this like taking a photocopy. The copied chart is now a static, independent object inside your Word document. It has no memory of where it came from.

Use this when:

• You are creating a one-time report that won't need to be updated.
• The source data is finalized and will not change.
• You want the recipient of the Word doc to have all the data contained within it, without needing the separate Excel file.

Linking

Linking, on the other hand, creates a live connection between the Excel source and the chart in your Word document. It’s like creating a direct portal. When you update the data in the Excel spreadsheet, the chart in the Word document can automatically reflect those changes.

Use this when:

• You’re creating a templated, recurring report (e.g., monthly sales summaries, weekly marketing reports, quarterly performance reviews).
• The source data is dynamic and will be updated frequently.
• You want to ensure your report always shows the most current information without manual re-work.

In short, embedding is for static, finalized documents, while linking is for dynamic, living ones.

Step-by-Step: How to Link Your Chart from Excel to Word

Getting this set up is simple once you know which options to pick. Let’s walk through the process with a common example: a monthly traffic report.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 1: Create and Copy Your Chart in Excel

First, get your chart ready in Excel. Select the chart you want to use. Be sure to click on the border of the chart object to select the entire thing, not just a single element like a bar or a title. Once it’s selected, copy it to your clipboard. The easiest way is with the keyboard shortcut Ctrl + C.

Step 2: Navigate to Word and Choose Your Spot

Open your Word document and place the cursor exactly where you want the chart to appear in your report.

Step 3: Use "Paste Special" to Create the Link

This is the most important step. Instead of just pressing Ctrl+V, you have a couple of better options to create a link. The goal is to open up more advanced pasting options.

On the Home tab in Word’s ribbon, click the small arrow under the Paste button. A dropdown menu will appear. From here, click Paste Special... at the bottom.

This opens the Paste Special dialog box, which gives you precise control over how the chart is inserted.

Step 4: Select "Paste Link" and Choose the Object Type

Inside the Paste Special box, you’ll see two options on the left: "Paste" and "Paste Link." Select "Paste Link."

Next, in the "As:" list, choose "Microsoft Excel Chart Object."

Click OK. Your chart will now appear in the Word document. On the surface, it looks just like a regular pasted chart, but behind the scenes, it's now connected to your original Excel file.

An Even Faster Way: Understanding the Right-Click Paste Options

If the "Paste Special" menu feels a bit too formal, you can get the same result with a quicker right-click. After copying your chart from Excel, right-click where you want it in Word. You'll see a small fly-out menu with several "Paste Options" represented by icons.

These can be confusing, but they are incredibly useful once you know what they mean. The ones relevant to linking are:

• Use Destination Theme & Link Data: This pastes the chart as a linked object but restyles it to match the colors and fonts of your Word template. Pick this if you want a consistent look and feel across your entire document.
• Keep Source Formatting & Link Data: This pastes the chart as a linked object while preserving the exact colors, fonts, and styling from your Excel file. Choose this if you've already perfected the chart's appearance in Excel and want it to look identical.

Both of these options create the live link you want. The other options either embed the workbook (making for a large file size) or paste it as a static picture (which can't be edited).

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

How to Update Your Linked Chart in a Word Document

Now that your chart is linked, it's time to see the magic happen. Go back to your original Excel spreadsheet and change one of the data points that the chart references. For instance, if you have a bar chart of monthly sales, increase a number.

If you have both the Word and Excel files open simultaneously, you will often see the chart in Word update in real-time. But sometimes, especially if the Word file was closed, you’ll need to manually refresh it.

Automatic Updates upon Opening

When you open a Word document that contains linked objects, you will often be greeted with a security prompt:

"This document contains links that may refer to other files. Do you want to update this document with the data from the linked files?"

Clicking Yes tells Word to check the source Excel file for any changes and update your charts accordingly. This is a great way to ensure your report is current the moment you open it.

Manually Updating a Specific Chart

If you're already working in the Word document and know that the source data has changed, you can force a refresh for a single chart.

Simply right-click on the chart and select "Update Link" from the context menu. Word will fetch the latest version of the chart from the linked Excel file and display it instantly. This is useful for making sure an individual chart is current without having to close and reopen the entire report.

Pro Tips for Managing Linked Files

Working with linked files is powerful, but it requires a bit of good housekeeping to avoid issues. Remember these tips to save a future headache.

1. File Paths are Everything

The link between your Word and Excel documents is based on the file path - the location of the file on your computer or network drive. If you move, rename, or delete the original Excel file, the link will break. Word will no longer know where to find the source data.

To prevent this, it’s best practice to keep your source Excel file and your Word report in the same folder, especially if you plan to share them with others. That way, if you move the folder to a different location, the relative path between the files remains intact.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

2. Editing and Changing the Source Link

So what do you do if a link inevitably breaks? Don't panic! Word has a dedicated menu for managing all the links in your document.

Go to File > Info. On the bottom right side of the screen, you’ll see a section called "Related Documents." Click on "Edit Links to Files."

This opens a "Links" dialog box showing every linked object in your document. From here you can:

• Update Now: Force a manual refresh of any selected links.
• Change Source: If you've moved or renamed the Excel file, you can use this to reconnect the chart to its new location.
• Break Link: Permanently sever the connection to the source file (more on that next).

3. How and Why to Break a Link

There are times when you’ll want to sever the live link and "freeze" a chart. For example, once a quarterly report is finalized and submitted, you don’t want the charts to accidentally change if someone updates the source data later. Breaking the link converts the chart into a static object - either a picture or an embedded Word object.

You can do this using the "Break Link" button in the "Edit Links to Files" menu mentioned above.

For a quicker option that works wonders, use this keyboard shortcut:

Select your chart in Word and press Ctrl + Shift + F9. This simple combination will unlink the selected object instantly, making it a permanent part of your document.

Final Thoughts

Tired of endlessly copy-pasting report visuals? Learning to link Excel charts to Word is a core skill for anyone who produces regular reports. It automates one of the most tedious manual tasks, reduces the chance of showing outdated information, and ensures consistency across your documents.

While this workflow is a game-changer for spreadsheets and documents, the modern need for reporting goes far beyond a single Excel file. Many teams grapple with data scattered across a dozen platforms like Google Analytics, Shopify, Salesforce, and Facebook Ads. In those cases, creating a single source of truth requires something even more automated. This is why we created Graphed. We connect directly to your various data sources to generate real-time dashboards using plain-English prompts. Instead of linking spreadsheets, you get live reports that are always up-to-date, saving you and your team hours of manual work every week.