{"id":400981,"date":"2022-01-29T19:00:05","date_gmt":"2022-01-29T16:00:05","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-save-or-publish-a-chart-from-google-sheets\/"},"modified":"2022-01-29T19:00:05","modified_gmt":"2022-01-29T16:00:05","slug":"how-to-save-or-publish-a-chart-from-google-sheets","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-save-or-publish-a-chart-from-google-sheets\/","title":{"rendered":"#How to Save or Publish a Chart From Google Sheets"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a29a5e241ff5\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a29a5e241ff5\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-save-or-publish-a-chart-from-google-sheets\/#Download_and_Save_a_Chart_From_Google_Sheets\" >Download and Save a Chart From Google Sheets<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-save-or-publish-a-chart-from-google-sheets\/#Publish_a_Chart_to_the_Web_in_Google_Sheets\" >Publish a Chart to the Web in Google Sheets<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-save-or-publish-a-chart-from-google-sheets\/#Unpublish_Your_Chart\" >Unpublish Your Chart<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Save or Publish a Chart From Google Sheets&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-731741\" srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"1200\" height=\"675\"\/><\/p>\n<p>When you create a graph in Google Sheets, you may want to use it outside that one spreadsheet. You can easily save a chart or publish it to the web so you can use it elsewhere or share it.<\/p>\n<p>You may have a pie chart showing revenue increases, an organizational chart with your company structure, or a line chart displaying sales across locations. You can <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">download<\/a> the chart to share it via email or post it on <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/social-mediaa\/\" data-internallinksmanager029f6b8e52c=\"1\" title=\"Social Media\" target=\"_blank\" rel=\"noopener\">social media<\/a>. Or you can publish it to the web as an interactive chart or static image and then share the link.<\/p>\n<p>With all the time you put into creating your chart, why not use it outside of Google Sheets?<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Download_and_Save_a_Chart_From_Google_Sheets\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_0\">Download and Save a Chart From Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Downloading a graph you create in Google Sheets takes only minutes. Plus, you can download it as a <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/9to5linux.com\/system76-teases-the-kudu-linux-laptop-for-expert-multitaskers\">PNG image<\/a>, PDF file, or SVG graphic.<\/p>\n<p>Sign into <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/docs.google.com\/spreadsheets\/\">Google Sheets<\/a> and open the spreadsheet containing the chart. Select the chart and click the three dots on the top right of it.<\/p>\n<p>Move your cursor to Download and pick one of the above three options.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-777721\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/01\/Download-GoogleSheetsSavePublishChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Chart download options in Google Sheets\" width=\"650\" height=\"336\"\/><\/p>\n<p>Depending on the browser or platform you\u2019re 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.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-777722\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/01\/OpenSave-GoogleSheetsSavePublishChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Firefox prompt to open or save the file\" width=\"374\" height=\"336\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Publish_a_Chart_to_the_Web_in_Google_Sheets\"><\/span>Publish a Chart to the Web in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Another handy option if you plan to share your chart is to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/442426\/how-to-share-a-google-docs-sheets-or-slides-file-as-a-web-page\/\">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.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Share a Google Docs, Sheets, or Slides File as a Web Page<\/em><\/strong><\/p>\n<p>Open the spreadsheet and select the chart. Click the three dots on the top right of it and pick \u201cPublish Chart.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-777723\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/01\/Publish-GoogleSheetsSavePublishChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select Publish Chart\" width=\"480\" height=\"380\"\/><\/p>\n<p>In the Publish to the Web window that appears, you can pick from various options before publishing the chart.<\/p>\n<p>You can either receive a link to the published chart (by clicking \u201cLink\u201d) or obtain the code to embed it on your site or blog (by clicking \u201cEmbed\u201d).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-777725\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/01\/LinkEmbed-GoogleSheetsSavePublishChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Link and Embed tabs\" width=\"539\" height=\"386\"\/><\/p>\n<p>Next, you\u2019ll 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.<\/p>\n<p>To the right, use the next drop-down box to choose if you want to publish an Interactive chart or static Image.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-777724\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/01\/FileInteractive-GoogleSheetsSavePublishChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"File and interactive or image drop-down boxes\" width=\"539\" height=\"386\"\/><\/p>\n<p>By using the Interactive option, those viewing your chart can move their cursor over certain areas to see more detail.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-777727 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/01\/InteractiveVSImage-GoogleSheetsSavePublishChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Interactive versus static image\" width=\"650\" height=\"273\"\/><\/p>\n<p>Expand Publish Content &amp; Settings and you\u2019ll see a drop-down list for what you\u2019d like to publish. To publish only the chart, open the drop-down list, click \u201cEntire Document\u201d to <em>deselect<\/em> it, and then choose the chart.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-777729\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/01\/SettingsChart-GoogleSheetsSavePublishChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select the chart\" width=\"398\" height=\"500\"\/><\/p>\n<p>Finally, you can check the box at the bottom to republish your chart if you make changes to it.\u00a0Click \u201cPublish\u201d when you finish and \u201cOK\u201d to confirm.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-777730\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/01\/PublishChart-GoogleSheetsSavePublishChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Automatically republish changes and Publish\" width=\"489\" height=\"500\"\/><\/p>\n<p>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.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-777733\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/01\/CopyLinkCode-GoogleSheetsSavePublishChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Link and Embed code\" width=\"1074\" height=\"376\"\/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Unpublish_Your_Chart\"><\/span>Unpublish Your Chart<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>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 \u201cPublish Chart.\u201d<\/p>\n<p>On either the Link or Embed tab, expand Published Content &amp; Settings and click \u201cStop Publishing.\u201d Confirm by clicking \u201cOK.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-777732\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/01\/StopPublishing-GoogleSheetsSavePublishChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Button to Stop Publishing\" width=\"434\" height=\"500\"\/><\/p>\n<p>If someone uses the link or code to view the chart after you stop publishing it, they\u2019ll see a message that the document is not published.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-777731\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/01\/NotPublished-GoogleSheetsSavePublishChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Message for unpublished chart\" width=\"355\" height=\"105\"\/><\/p>\n<p>By saving or publishing your chart, others can see the data you want them to using a great visual and without having to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/753171\/how-to-share-documents-on-google-docs-sheets-and-slides\/\">share your Google Sheets workbook.<\/p>\n<p>If you use Microsoft Excel in addition to Google Sheets, see how to save a chart as an image in Excel too.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/777718\/how-to-save-or-publish-a-chart-from-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Save or Publish a Chart From Google Sheets&#8221; When you create a graph in Google Sheets, you may want to use it outside that one spreadsheet. You can easily save a chart or publish it to the web so you can use it elsewhere or share it. You may have a pie chart&#8230;<\/p>\n","protected":false},"author":1,"featured_media":400982,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-400981","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/400981","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=400981"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/400981\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/400982"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=400981"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=400981"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=400981"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}