Integration and publishing in Google Sheets
1. Integration and publishing in Google Sheets
Person: Google Docs and Google Slides both support Google Sheets charts. To add a chart in Docs or Slides, open the Insert menu, hover over Chart, and click "From Sheets." From the Insert Chart dialog, search for a spreadsheet or browse the thumbnails or list of spreadsheets in Google Drive. Click a spreadsheet and click "Select." View the previews of the charts in the spreadsheet, select one, and click "Import." By default, the inserted chart will remain linked to the spreadsheet, but you can uncheck that box to remove the link. Once the chart is inserted, the text wrap options and image options can be changed. Click the linked chart options button to either unlink the chart, open source to see the spreadsheet where the chart originated from, or view linked objects. Linked objects are displayed in a panel, and clicking them will open the spreadsheet in a new tab. Once the chart has been added, this menu will also contain an option to update, which populates the linked chart with the most recent data from the linked spreadsheet. A table can also be added to a Google Docs or Google Slides document from Google Sheets. Open the spreadsheet in Google Sheets. Select the cells in the table, Open the Edit menu, and click "Copy." Open a Google Docs or Google Slides document, click in the location to add the table in a document, open the Edit menu, and click "Paste." Choose to "Link to spreadsheet" or "Paste unlinked." click the "More Options" button in the upper right corner of the chart to edit, delete, download, publish, or copy the chart. You can also move the chart to its own sheet, and add alt text from the More options menu. To make the chart public, choose "Publish chart." It can be shared via a link, or embedded in a website. To create a link to the chart, click "Link" on the Publish to the web card. Choose to publish just the chart, a sheet, or the entire document. Choose to make it interactive, or just an image. A unique shareable link will be created and displayed. Under "Published content and settings," choose if only the chart, a sheet, or the entire document underlying the chart is also published. Click "Stop publishing" to turn off public access to the data. Click the Embed tab to create an embed code for adding a chart to a website. Again, choose to publish the chart, the sheet, or the entire document, and whether it will be interactive or an image. Google Sheets will generate custom embed HTML code. If you're comfortable, you can edit the code either prior to or after adding it to a website. To use the embed code, copy and paste it. Click "Stop publishing" to disable public access to the chart. With either option, choose to automatically republish when changes are made to ensure that the published chart is always displaying the most up-to-date data as the spreadsheet that underlies it. The Google Sheet can be made completely public by publishing it to the web on a website. Click "File," and then "Publish to the web" to choose your options for making the spreadsheet public. Sheets can also be published as a link, or embedded in a web page. Choose if your colleagues must be signed in to their Google Workspace account to view the spreadsheet, or if it can be viewed anonymously. You can also choose if you want the spreadsheet to be republished automatically after a content change.2. Let's practice!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.