Sometimes you want to add data from a Google sheet to a Google Doc or Slide. Even if you can't directly insert cells and rows from Ark, you can create a table, chart, or image, and then insert it into your document or image.
Note: We use Google Docs in these examples, but inserting a chart into slides works virtually the same.
First, you need to create a chart in your Google Sheets spreadsheet. You can do that by postponing your Google Sheets website and opening a new or existing spreadsheet.
Once you have entered some data and stored it in a spreadsheet, select all cells and click Insert> Chart. Choose a carton type, make some adjustments and make some final adjustments, and then close Ark ̵1; worry, Google saves after each step. We have an article on how to create charts in Ark if you want to learn more.
Once you've created a chart in Google Sheets, you can open Google Docs and open a new or existing document to insert your chart. Click "Insert", point to "Chart" and then click "From Sheets."
On the list of available spreadsheets choose the one you want to use and then click "Select".
The next window shows all the charts on the sheet available for import. Click on one and then click "Import."
You also have another option here. Check the box "Link to spreadsheets" in the screenshot above? If you enable it, the chart in your Doc or Slide will be linked to the original chart in your Ark. Make changes to your sheet, and you'll see the chart in your document or slideshow updated automatically to reflect those changes. Disable this check box if you do not want it to happen; in that case, the chart is frozen in time in your image or image. If you want to update it, you need to re-insert it.
If you leave the link option enabled, you can at any time click "Update" to synchronize the data in the chart or table with the document Sheets
Since these charts are saved as images, is a fun quirk when you use the insert feature that if the originals are not scaled or appropriately sized to see all the data, points can be cut off when you update it.
Voila! Your Google Sheets data is now included in your Google Doc.
If for some reason you do not like your update of the chart and links to your Sheets document anymore, click on a chart, then click on the chain icon and then "Unlink "to remove the link function.
RELATED: How to use Google Docs Offline
This disables the ability to make changes to Sheets and get them automatically appear inside your document without returning it. If you want an updated chart or want to re-establish the link, repeat the steps from above.