Sometimes you want to paste data from a Google Sheet into a Google Doc or slide. While you can not insert cells and rows directly from sheets, you can create a table, chart, or slide and then paste them into your document or slide.
Note: We'll use Google Docs in these documents for examples, but inserting a diagram into Slides works the same way.
First, you'll need to create a chart in your Google Sheets spreadsheet. You can do this by launching the Google Sheets home page and opening a new or existing spreadsheet.
After you have entered some data and saved it in a table, select all cells and click Insert> Diagram. Select a chart type, make adjustments, and make the final adjustments. Then close the leaves. Do not worry, Google saves after every step. We have an article on creating charts in Sheets for more information.
After you create a chart in Google Sheets, launch Google Docs and open it. A new or existing document to insert your chart. Click "Paste," point to "Chart," and then click "From Sheets."
Select the table you want from the list of available tables Click Select.
The next window lists all the charts on this worksheet that are available for import. Click on one and then on "Import".
You also have another option here. See the "Link to Table" checkbox in the screenshot above? If you enable it, the chart in your document or slide will be linked to the original chart in your sheet. Make changes to your worksheet. The chart in your document or slide is automatically updated to reflect these changes. Uncheck this box if you do not want this. In this case, the chart will be frozen on your slide or sheet. If you want to update it, you must reinsert it.
If you leave the Link option turned on, you can click Refresh at any time to synchronize the data in the chart or spreadsheet with your Sheets document
 Since these diagrams are saved as images, the use of the paste function is a funny feature: if the original is not scaled or resized, all data and some data will be displayed. Points could be truncated when refreshing.
Voila! Your Google Sheets data will now be included in your Google Doc.
If, for some reason, you no longer like updating your chart and linking it to your sheet-based document, click a chart, then click the chain icon and then again on "Unlink" to remove the link function.
RELATED: Offline use of Google Docs
This disables the ability to make changes to sheets automatically in your Document without having to reinsert it. If you want an updated chart or want to reconnect, repeat the steps from the top.