Graphs are the ideal way to visually represent data from a spreadsheet. If you want to insert a chart from an existing spreadsheet into a Docs or Slides file, you can sync it with Google Sheets.

First, make sure you have a Google Sheets spreadsheet that contains at least one chart. You can follow our instructions to insert the chart manually or by using the Google Explore feature.

RELATED: How to Create Instant Graphs with Google Sheets Viewer

In this tutorial, we’ll be using Google Docs to sync charts from tables, although the process is identical for slides.

Launch your browser, go to Google Docs, and then open the document you want to sync the chart from Sheets to.

Click Insert > Chart > From Sheet to open the chart selection window.

Click Insert, click Chart, and then choose From Sheets.

This will open a list of all spreadsheets saved in your Google Drive. Find the table with the chart you want and double click on it.

Double-click the spreadsheet containing the desired chart.

All graphs in the spreadsheet will appear in the window. Select the one you want and then click «Import» to add it to your document. If there are no charts on the sheet, just click the back button and choose another file.

Click on the chart you want to insert and click Import.

Once the chart is pasted into the document, click on it and then drag any of the blue squares to resize it to fit into the document.

Click on the chart and drag the little blue squares to resize it.

Although the chart does not update in real time, you see a notification every time the data in the tables changes. Just click «Refresh» in the right corner of the diagram in your document and wait for it to update.

Click

That’s all there is to it! If you want to add more charts from other spreadsheets, just repeat the steps above and insert as many as you need.

Похожие записи