How to Embed a Live Google Sheets Chart into a Google Doc

When writing a professional report, a financial summary, or a project update in Google Docs, visualising your data is essential. The most common workflow involves creating a chart in a spreadsheet, taking a screenshot, and pasting that static image into the text document.

However, taking screenshots is incredibly inefficient. If your underlying data changes—even by a single digit—you must recreate the chart, take a new screenshot, delete the old image in your document, and paste the new one. By using Google’s ecosystem effectively, you can embed a live, dynamically linked chart directly from Google Sheets into your Google Doc. When the spreadsheet updates, the chart in your document updates with a single click.

Prerequisites for Linking Charts

Before you begin, ensure you have both files prepared and saved within your Google Drive account:

• A Google Sheet containing your raw data and a fully formatted chart.
• A Google Doc where you want the chart to appear.

Both files must belong to the same Google account for the linking mechanism to work seamlessly.

How to Embed the Chart

The process of embedding the chart relies on the standard copy-and-paste function, but the way Google Docs handles the pasted object is what creates the dynamic link.

Step 1: Copy the Chart from Google Sheets

1. Open your Google Sheet containing the chart.
2. Click once anywhere on the chart to select it. You should see a blue border appear around the chart area.
3. Click the three vertical dots (the “More” icon) located in the top-right corner of the chart box.
4. Select Copy chart from the drop-down menu. (Alternatively, press Ctrl + C on Windows or Command + C on Mac).

Step 2: Paste and Link in Google Docs

1. Open your Google Doc.
2. Place your cursor exactly where you want the chart to be inserted.
3. Right-click and select Paste (or press Ctrl + V / Command + V).
4. A critical “Paste chart” dialog box will immediately appear on your screen. This box gives you two options.
5. Ensure the option for Link to spreadsheet is selected.
6. Click the Paste button.

Your chart will now appear inside your Google Doc. Visually, it looks exactly like an image, but it is secretly tethered to your original spreadsheet.

How to Update the Linked Chart

The primary benefit of this method is the ease of updating. When new data arrives, you only need to modify the numbers in your Google Sheet.

1. Open your original Google Sheet and change the data values. The chart inside the spreadsheet will update automatically.
2. Return to your Google Doc.
3. You will notice a new Update button floating in the top-right corner of the embedded chart.
4. Click the Update button.

The chart in your Google Doc will instantly refresh to reflect the new data, colours, and formatting you applied in the spreadsheet. You do not need to delete or re-paste anything.

How to Unlink a Chart

If you finalise a report and want to guarantee that the chart will never change again, even if someone accidentally alters the source spreadsheet, you can sever the connection.

1. Click on the embedded chart in your Google Doc to select it.
2. Click the Linked chart options icon (it looks like a chain link with a small arrow) in the top-right corner of the chart.
3. Select Unlink from the drop-down menu.

The chart is now permanently converted into a static image and will no longer respond to changes made in the original Google Sheet.