Sometimes, you want to add data from a Google Sheet into a Google Doc or Slide. Although you can’t directly insert cells and rows from Sheets, you can create a table, chart, or slide, and then insert that into your Doc or Slide.
Note: We will be using Google Docs in these examples but inserting a chart into Slides works virtually the same way.
First, you’ll need to generate a chart in your Google Sheets spreadsheet. You can do this by firing up your Google Sheets homepage and opening a new or existing spreadsheet.
After inputting some data and storing it in a spreadsheet, select all the cells and click Insert > Chart. Choose a chart type, make any adjustments, and do any final customizations, then close Sheets–don’t worry, Google saves after every step. We’ve got an article about generating charts in Sheets if you want to learn more.
After you’ve created a chart in Google Sheets, fire up Google Docs and open a new or existing document to insert your chart. Click “Insert,” point to “Chart,” and then click on “From Sheets.”
From the list of available spreadsheets, select the one you want to use and then click “Select.”
Read the remaining 16 paragraphs
Source : How to Insert a Google Sheets Spreadsheet into Google Docs
