How to Save or Publish a Chart From Google Sheets

Download and Save a Chart From Google Sheets

Downloading a graph you create in Google Sheets takes only minutes. Plus, you can download it as a PNG image, PDF file, or SVG graphic.

Sign into Google Sheets and open the spreadsheet containing the chart. Select the chart and click the three dots on the top right of it.

Move your cursor to Download and pick one of the above three options.

Depending on the browser or platform you’re using, the chart may download automatically, or you may be asked to open or save the file. Simply follow the prompts for your browser to obtain the chart.

Publish a Chart to the Web in Google Sheets

Another handy option if you plan to share your chart is to publish it to the web. With this option, you can make the graph interactive or static, and automatically republish it if you make changes to the chart.

Open the spreadsheet and select the chart. Click the three dots on the top right of it and pick “Publish Chart.”

In the Publish to the Web window that appears, you can pick from various 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 on your site or blog (by clicking “Embed”).

Next, you’ll see a drop-down box with your chart selected by default. If you prefer to obtain a link or the code for the entire sheet or workbook, you can select it from that drop-down list.

To the right, use the next drop-down box to choose if you want to publish an Interactive chart or static Image.

By using the Interactive option, those viewing your chart can move their cursor over certain areas to see more detail.

Expand Publish Content & Settings and you’ll see a drop-down list for what you’d like to publish. To publish only the chart, open the drop-down list, click “Entire 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 finish and “OK” to confirm.

Then copy the link or embed code and paste it where needed. You can also directly share the link to Gmail, Facebook, or Twitter if you like.

Unpublish Your Chart

Once you publish your chart to the web, you can stop publishing anytime. Reopen the Publish to the Web window by clicking the three dots on the top right of the chart and picking “Publish Chart.”

On either the Link or Embed tab, expand Published Content & Settings and click “Stop Publishing.” Confirm by clicking “OK.”

If someone uses the link or code to view the chart after you stop publishing it, they’ll see a message that the document is not published.

By saving or publishing your chart, others can see the data you want them to using a great visual and without having to share your Google Sheets workbook.