{"id":516979,"date":"2022-11-27T21:00:46","date_gmt":"2022-11-27T18:00:46","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-create-a-combo-chart-in-google-sheets\/"},"modified":"2022-11-27T21:00:46","modified_gmt":"2022-11-27T18:00:46","slug":"how-to-create-a-combo-chart-in-google-sheets","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-combo-chart-in-google-sheets\/","title":{"rendered":"#How to Create a Combo Chart 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-6a2fe388d3b17\" 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-6a2fe388d3b17\" 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-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-combo-chart-in-google-sheets\/#%E2%80%9CHow_to_Create_a_Combo_Chart_in_Google_Sheets%E2%80%9D\" >&#8220;How to Create a Combo Chart in Google Sheets&#8221;<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-combo-chart-in-google-sheets\/#Set_Up_the_Data\" >Set Up the Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-combo-chart-in-google-sheets\/#Create_the_Combo_Chart\" >Create the Combo Chart<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-combo-chart-in-google-sheets\/#Customize_the_Combo_Chart\" >Customize the Combo Chart<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CHow_to_Create_a_Combo_Chart_in_Google_Sheets%E2%80%9D\"><\/span>&#8220;How to Create a Combo Chart in Google Sheets&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone wp-image-741481 size-full\" data-pagespeed-no-defer=\"\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/Google-Sheets-Logo-Lede.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"The Google Sheets logo.\" width=\"1200\" height=\"675\"\/><\/p>\n<p>Create two columns with your primary data <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> in the left column and the secondary data on the right. Then, click Insert &gt; Chart and insert a Combo Chart. Google may suggest a Combo Chart, or you may have to select &#8220;Combo Chart&#8221; from the &#8220;Chart Type&#8221; box in the Chart Editor.<\/p>\n<p>Picking out the best chart for effectively displaying related data isn\u2019t always easy. Using a combo chart in Google Sheets, you can take advantage of two charts combined for the ideal visual.<br \/>\nA combo chart combines a column and line graph into a single chart. The result is a simple way for you and your audience to view each data series in a new way.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Set_Up_the_Data\"><\/span>Set Up the Data<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Combo charts are helpful when you want to show a relationship between two or more data sets that are measured differently. For example, you may <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/434259\/how-to-create-a-combo-chart-in-excel\">use a combo chart to show projected sales and actual sales, temperatures with precipitation amounts, or revenue and income with profit margin.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Create a Combo Chart in Excel<\/em><\/strong><\/p>\n<p>Because Google Sheets offers the column and line combo chart, you\u2019ll set up your primary series of data in a column on the left and the secondary data in the column to the right.<\/p>\n<p>For a basic example, we\u2019ll use the data you see below, which is monthly traffic to a website with the total sales generated from that traffic.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-838314\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/10\/PrimaryTraffic-GoogleSheetsComboChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Primary data series Traffic\" width=\"300\" height=\"180\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The traffic data is our primary series on the left, and the sales data is the second series on the right. The result is a combo chart that displays the traffic via a column chart and the sales via a\u00a0line chart.<\/p>\n<p>If we want to show the opposite, we\u2019d switch the columns, as shown below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-838313\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/10\/PrimarySales-GoogleSheetsComboChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Primary data series Sales\" width=\"300\" height=\"180\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Once you have your data ready, it\u2019s time to create your combo chart.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Create_the_Combo_Chart\"><\/span>Create the Combo Chart<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Select the data you want to include in your chart. Go to the Insert tab and click \u201cChart.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-838316\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/10\/InsertChart-GoogleSheetsComboChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Chart on the Google Sheets Insert menu\" width=\"294\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Google Sheets displays the <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/406381\/how-to-automatically-generate-charts-in-google-sheets\/\">type of chart it believes fits your data best. So, you may see a combo chart right off the bat.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Automatically Generate Charts in Google Sheets<\/em><\/strong><\/p>\n<p>If not, go to the Setup tab in the Chart Editor sidebar that opens at the same time. Use the Chart Type drop-down menu to select the Combo Chart in the Line section.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-838317\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/10\/ChartType-GoogleSheetsComboChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Combo Chart in the Chart Type menu\" width=\"650\" height=\"264\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Once you have your combo chart, you can use the additional settings on the Setup tab in the Chart Editor as needed. You can do things like add labels to a series and use the first row of your data as headers.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-838318\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/10\/ChartEditorSetup-GoogleSheetsComboChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Chart Editor Setup tab section\" width=\"232\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Customize_the_Combo_Chart\"><\/span>Customize the Combo Chart<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>After you have the data set up the way you want it, you can customize the <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>earance of your chart by adjusting the title, changing the fonts, and choosing different colors.<\/p>\n<p>Go to the Customize tab in the Chart Editor sidebar. If you\u2019ve already closed it, double-click your chart or click the three dots on the top right. Then, click \u201cEdit Chart.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-838319\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/10\/EditChart-GoogleSheetsComboChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Edit Chart in the chart menu\" width=\"650\" height=\"343\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You\u2019ll see several sections you can expand on the Customize tab:<\/p>\n<ul>\n<li><strong>Chart Style<\/strong>: Adjust the background color, border color, and font.<\/li>\n<li><strong>Chart &amp; Axis Titles<\/strong>: Edit or add a chart title, subtitle, or axis title and select the font style, color, and size.<\/li>\n<li><strong>Series<\/strong>: Format each series on the chart, including fill and line colors. Add error bars, data labels, or a trendline.<\/li>\n<li><strong>Legend<\/strong>: Reposition the legend, remove it, or adjust the font.<\/li>\n<li><strong>Horizontal Axis<\/strong>: Choose a font and color for the labels.<\/li>\n<li><strong>Vertical Axis<\/strong>: Pick the font and color for the labels, add a minimum or maximum, and choose a number format.<\/li>\n<li><strong>Gridlines and Ticks<\/strong>: Format the gridlines and colors, or add ticks.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-838320\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/10\/ChartEditorCustomize-GoogleSheetsComboChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Chart Editor Customize tab section\" width=\"304\" height=\"500\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you see an element on your chart that you want to customize but aren\u2019t sure which section to go to, simply click that part of the chart. The corresponding section opens in the Chart Editor sidebar for you to make your adjustments.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-838321\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/10\/EditChartSelect-GoogleSheetsComboChart.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Chart element selected with corresponding section in the Chart Editor\" width=\"650\" height=\"275\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you have relational data that you want to display visually, consider creating a combo chart in Google Sheets. For more, check out how to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/762481\/how-to-make-a-pie-chart-in-google-sheets\/\">make a pie chart or how to create a bar graph in Sheets.<\/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>\n<\/p><\/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\/838307\/how-to-create-a-combo-chart-in-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How to Create a Combo Chart in Google Sheets&#8221; Create two columns with your primary data series in the left column and the secondary data on the right. Then, click Insert &gt; Chart and insert a Combo Chart. Google may suggest a Combo Chart, or you may have to select &#8220;Combo Chart&#8221; from the &#8220;Chart&#8230;<\/p>\n","protected":false},"author":1,"featured_media":516980,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/07\/Google-Sheets-Logo-Lede.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-516979","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\/516979","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=516979"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/516979\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/516980"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=516979"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=516979"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=516979"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}