Save or publish a chart from Google Sheets
When you create a chart in Google Sheets, you may want to use it outside of that one spreadsheet. You can easily save a chart or publish it on the web so that you can use or share it elsewhere.
You may have a pie chart showing sales increases, an org chart showing your business structure, or a line chart showing sales in different locations. You can download the chart to share via email or post on social media. Or you can publish it on the web as an interactive chart or static image and then share the link.
With all the time you spend creating your chart, why not use it outside of Google Sheets?
Downloading a chart you create in Google Sheets only takes a few minutes. Plus, you can download it as a PNG image, PDF file or SVG image.
login Google Sheets and open the spreadsheet with the chart. Select the chart and click on the three dots in the top right corner of it.
Move your cursor to Download and choose one of the above three options.
Depending on the browser or platform you are using, the map may be downloaded automatically or you may be prompted to open or save the file. Just follow the directions for your browser to get the chart.
Publish a chart to the web in Google Sheets
Another useful option if you plan to share your chart is: publish on the web. This option allows you to make the chart interactive or static and republish it automatically when you make changes to the chart.
RELATED: How to Share a Google Docs, Sheets, or Slides File as a Web Page
Open the worksheet and select the chart. Click the three dots in the top right corner and choose “Publish Chart.”
In the Publish to the Web window that appears, you can choose from several options before publishing the chart.
You can either receive a link to the published chart (by clicking ‘Link’) or obtain the code to embed it in your site or blog (by clicking ‘Embed’).
Then you will see a drop-down list with your chart selected by default. If you prefer to receive a link or the code for the whole worksheet or workbook, you can select it from that drop-down list.
Use the following drop-down menu on the right to choose whether you want to publish an interactive chart or a static image.
By using the Interactive option, those viewing your map can move their cursor over certain areas to see more detail.
Expand Publish Content and Settings and you’ll see a drop-down list of what you want to publish. If you just want to publish the chart, open the drop-down list, click “Full Document” to deselect it, and then choose the chart.
Finally, you can check the box at the bottom to republish your chart if you make changes to it. Click “Publish” when you’re done and “OK” to confirm.
Then copy the link or embed code and paste it where necessary. You can also share the link directly to Gmail, Facebook, or Twitter if you’d like.
Unpublish your diagram
After you have published your diagram on the web, you can stop publishing it at any time. Open the Publish to the Web window again by clicking the three dots in the top right corner of the chart and choosing “Publish Chart”.
On the Link or Embed tab, expand Published Content and Settings and click “Stop Publishing.” Confirm by clicking “OK”.
If someone uses the link or code to view the diagram after you stop publishing, they will see a message that the document has not been published.
Saving or publishing your diagram allows others to see the data you want them to see with a great visual and without them having to share your Google Sheets workbook.
If you also use Microsoft Excel in addition to Google Sheets, see how you can also save a chart as an image in Excel.