{"id":370071,"date":"2021-11-20T23:00:53","date_gmt":"2021-11-20T20:00:53","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-make-a-bar-graph-in-google-sheets\/"},"modified":"2021-11-20T23:00:53","modified_gmt":"2021-11-20T20:00:53","slug":"how-to-make-a-bar-graph-in-google-sheets","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-bar-graph-in-google-sheets\/","title":{"rendered":"#How to Make a Bar Graph in Google Sheets"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 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-6a3bb8cbf123d\" 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-6a3bb8cbf123d\" 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-make-a-bar-graph-in-google-sheets\/#Make_a_Bar_Chart_in_Google_Sheets\" >Make a Bar Chart in 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-make-a-bar-graph-in-google-sheets\/#Customize_a_Bar_Graph_in_Google_Sheets\" >Customize a Bar Graph 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-make-a-bar-graph-in-google-sheets\/#Modify_the_Series\" >Modify the Series<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-bar-graph-in-google-sheets\/#Format_a_Data_Point\" >Format a Data Point<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-make-a-bar-graph-in-google-sheets\/#Add_Error_Bars\" >Add Error Bars<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Make a Bar Graph in Google Sheets&#8221;<\/strong><\/p>\n<div>\n<!-- UNCACHED CONTENT --><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-768195\" srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/GoogleSheetsBarChart.png?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/GoogleSheetsBarChart.png?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\/11\/GoogleSheetsBarChart.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Bar chart in Google Sheets\" width=\"1200\" height=\"675\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you have data sets that you want to compare or show a trend over time, create a bar graph. In Google Sheets, you can make a bar chart and customize it most any way you like.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Make a Bar Chart in Microsoft Excel<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Make_a_Bar_Chart_in_Google_Sheets\"><\/span>Make a Bar Chart in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Select the data for the chart by dragging your cursor through the range of cells. Then, go to Insert in the menu and select \u201cChart.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-768199\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/InsertChart-GoogleSheetsBarChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select Insert, Chart\" width=\"400\" height=\"390\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Google Sheets adds a default chart into your spreadsheet which is normally a column chart. However, you can switch this to a bar graph easily.<\/p>\n<p>When the chart <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\">app<\/a>ears, you should see the Chart Editor sidebar open as well. Select the Setup tab at the top and click the Chart Type drop-down box. Scroll down and choose the Bar chart.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-768200\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/ChartTypeBar-GoogleSheetsBarChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select the Bar chart\" width=\"400\" height=\"364\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll see the chart update im<a href=\"https:\/\/buradabiliyorum.com\/en\/category\/social-mediaa\/\" data-internallinksmanager029f6b8e52c=\"1\" title=\"Social Media\" target=\"_blank\" rel=\"noopener\">media<\/a>tely to the new type, ready for you to customize if you like.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-768198\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/InsertedChart-GoogleSheetsBarChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Bar chart inserted in Google Sheets\" width=\"650\" height=\"281\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Automatically Generate Charts in Google Sheets<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Customize_a_Bar_Graph_in_Google_Sheets\"><\/span>Customize a Bar Graph in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The graphs you create in Google Sheets offer most of the same customization options. You can change the title, add axis titles, pick a background color, and select the font style.<\/p>\n<p>Open the Chart Editor sidebar by clicking the three dots on the top right of the graph and picking \u201cEdit Chart.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-768201\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/EditChart-GoogleSheetsBarChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Pick Edit Chart\" width=\"650\" height=\"404\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Select the Customize tab at the top of the sidebar. You\u2019ll then see your customization options listed and collapsed, so you can expand whichever you want to work on.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-768202\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/ChartEditorCustomize-GoogleSheetsBarChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click the Customize tab\" width=\"289\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Let\u2019s take a look at few options you may want to change specifically for the bar chart.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>The Best Fonts for Google Docs Documents<\/em><\/strong><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Modify_the_Series\"><\/span>Modify the Series<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The graph uses default colors for each of the bars, but you can change these to match your company or organization\u2019s colors.<\/p>\n<p>Expand the <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/watch-movies-tv-seriess\/\" data-internallinksmanager029f6b8e52c=\"8\" title=\"Watch Movies &amp; TV Series\" target=\"_blank\" rel=\"noopener\">Series<\/a> section in the sidebar. Then click the Apply to All Series drop-down list and choose the series you want to change.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-768204\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/SelectSeries-GoogleSheetsBarChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select the series\" width=\"650\" height=\"309\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can then adjust the color and opacity for both the fill and the line. You can also choose a different line type and select the thickness.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-768203\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/AdjustSeries-GoogleSheetsBarChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Change the series colors and lines\" width=\"650\" height=\"287\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Format_a_Data_Point\"><\/span>Format a Data Point<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>If you want to highlight a specific bar on the chart, you can format it to make it stand out. Below the line options in the Series section, click \u201cAdd\u201d next to Format Data Point.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-768206\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/FormatDataPointAdd-GoogleSheetsBarChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Add\" width=\"338\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When the pop-up window displays, either click the point on the chart or select it from the drop-down list. Click \u201cOK.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-768205\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/SelectDataPoint-GoogleSheetsBarChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select the data point\" width=\"500\" height=\"292\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll then see a color palette display in the sidebar by the data point. Pick the color you want to use and the chart will update.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-768208\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/FormatDataPointColor-GoogleSheetsBarChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Choose a color\" width=\"329\" height=\"494\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can follow the same process to format additional data points. To change or remove the data point, select a different one from the drop-down list or click \u201cDelete\u201d beneath it in the sidebar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-768207\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/FormatDataPoints-GoogleSheetsBarChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Formatted data points\" width=\"650\" height=\"267\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Add_Error_Bars\"><\/span>Add Error Bars<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>You can also add error bars to your chart based on value, percentage, or standard deviation. At the bottom of the Series section in the sidebar, check the box next to Error Bars.<\/p>\n<p>Then choose Constant, Percent, or Standard Deviation in the drop-down list and enter the value you want to use to the right.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-768209\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/ErrorBarsAdd-GoogleSheetsBarChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Add error bars to the chart\" width=\"400\" height=\"328\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Your chart will display these error bars on the right sides of the bars.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-768210\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/ErrorBarsAdded-GoogleSheetsBarChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Error bars on the chart\" width=\"650\" height=\"267\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Creating a bar graph in Google Sheets is easy, and the customization options allow you to perfect the appearance of your chart.\u00a0If you are limited on space, take a look at how to use sparklines in Google Sheets instead.<\/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\/768192\/how-to-make-a-bar-graph-in-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Make a Bar Graph in Google Sheets&#8221; If you have data sets that you want to compare or show a trend over time, create a bar graph. In Google Sheets, you can make a bar chart and customize it most any way you like. RELATED: How to Make a Bar Chart in Microsoft&#8230;<\/p>\n","protected":false},"author":1,"featured_media":370073,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/11\/GoogleSheetsBarChart.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-370071","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\/370071","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=370071"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/370071\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/370073"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=370071"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=370071"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=370071"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}