{"id":20426,"date":"2024-12-24T18:00:28","date_gmt":"2024-12-24T13:00:28","guid":{"rendered":"https:\/\/ppcexpo.com\/blog\/?p=20426"},"modified":"2026-01-10T21:15:00","modified_gmt":"2026-01-10T16:15:00","slug":"google-sheets-combo-chart","status":"publish","type":"post","link":"https:\/\/ppcexpo.com\/blog\/google-sheets-combo-chart","title":{"rendered":"How to Create a Combo Chart in Google Sheets?"},"content":{"rendered":"<p>A Combination Chart is a must-have tool in a professional&#8217;s arsenal that frequently works with data.<\/p>\n<p><em>Why?<\/em><\/p>\n<p>Combo Charts in Google Sheets can help you save a lot of space in your dashboard. This is because it lets you display insights into two different metrics in a single view.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2024\/09\/Combo-Chart-in-Google-Sheets-Main.jpg\" alt=\"Google Sheets combo chart\"><\/div>\n<div style=\"text-align: center;\">Source:chartexpo.com<\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZytncytwcGMrNjE5Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/google-sheets-combo-chart-button-3.jpg\" alt=\"Google Sheets combo chart\"><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZyt4bCtwcGMrNjE5Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/google-sheets-combo-chart-button-4.jpg\" alt=\"Google Sheets combo chart\"><\/a><\/div>\n<p><em>Here\u2019s an interesting fact.<\/em><\/p>\n<p>Combination Graphs perform the job of two diagrams. Your dashboard does not have to appear crowded with many charts. You can use this visualization design to save space.<\/p>\n<p>You cannot find a ready-made Combination Graph in Google Sheets. This is because the tool comes with raw and basic charts that need more editing time.<\/p>\n<p>You don\u2019t have to do away with Google Sheets for other expensive tools. You can supercharge it by installing third-party add-ons to access Google Sheets Combo Chart templates.<\/p>\n<p>In this blog, you\u2019ll learn the following:<\/p>\n<h3>Table of Content:<\/h3>\n<ol>\n<li><a href=\"#how-to-make-google-sheets-combo-chart\">How to Make a Combo Chart in Google Sheets Using Its Editor?<\/a>\n<ol>\n<li><a href=\"#step1\">Step 1: Select Data Range<\/a><\/li>\n<li><a href=\"#step2\">Step 2: Open the Chart Editor<\/a><\/li>\n<li><a href=\"#step3\">Step 3: Select Chart Type<\/a><\/li>\n<li><a href=\"#step4\">Step 4: Add a Line to the Chart<\/a><\/li>\n<li><a href=\"#step5\">Step 5: You\u2019ve Created a Combo Graph<\/a><\/li>\n<li><a href=\"#step6\">Step 6: Customize Your Combo Chart<\/a><\/li>\n<\/ol>\n<\/li>\n<li><a href=\"#how-to-make-google-sheets-combo-chart\">How to Create Combo Charts in Google Sheets?<\/a>\n<ol>\n<li><a href=\"#collect-and-arrange-data\">Step 1: Arrange Data For Combo Chart<\/a><\/li>\n<li><a href=\"#install-chartexpo\">Step 2: Install ChartExpo Add-In<\/a><\/li>\n<li><a href=\"#add-new-chart\">Step 3: Click the Add New Chart<\/a><\/li>\n<li><a href=\"#select-chart\">Step 4: Select Combo Chart<\/a><\/li>\n<li><a href=\"#edit-chart\">Step 5: Edit And Create Chart Button<\/a><\/li>\n<li><a href=\"#final-chart\">Step 6: Final Combo Chart Below<\/a><\/li>\n<\/ol>\n<\/li>\n<li><a href=\"#google-sheets-combo-chart-faqs\">How to Create a Combo Chart in Google Sheets: FAQs<\/a><\/li>\n<li><a href=\"#wrap-up\">Wrap Up<\/a><\/li>\n<\/ol>\n<h2>Video Tutorial: How to Create in Combo Chart Google Sheets<\/h2>\n<p><iframe loading=\"lazy\" title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/FOZXJv-Xfs0?si=wS_x55E2xEUK44Uw\" width=\"650\" height=\"365\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZytncytwcGMrNjE5Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/google-sheets-combo-chart-button-3.jpg\" alt=\"Google Sheets combo chart\"><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZyt4bCtwcGMrNjE5Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/google-sheets-combo-chart-button-4.jpg\" alt=\"Google Sheets combo chart\"><\/a><\/div>\n<h2 id=\"how-to-make-google-sheets-combo-chart\">How to Make a Combo Chart in Google Sheets Using Its Editor?<\/h2>\n<h3 id=\"step1\">Step 1: Select Data Range<\/h3>\n<p>Start by highlighting the range of data you want to include in your combo chart. Ensure it includes all the categories and values for both the bar and line components.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2024\/11\/Select-Data.jpg\" alt=\"Google Sheets combo chart 1\"><\/div>\n<h3 id=\"step2\">Step 2: Open the Chart Editor<\/h3>\n<p>Go to the <strong>Insert<\/strong> menu and select <strong>Chart<\/strong>. This will open the Chart Editor on the right side of your Google Sheet.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2024\/11\/Open-Chart-Creator.jpg\" alt=\"Google Sheets combo chart 2\"><\/div>\n<h3 id=\"step3\">Step 3: Select Chart Type<\/h3>\n<p>In the Chart Editor, navigate to the <strong>Setup<\/strong> tab and choose <strong>Combo Chart<\/strong> as the chart type from the dropdown menu.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2024\/11\/Select-Chart-type.jpg\" alt=\"Google Sheets combo chart 3\"><\/div>\n<h3 id=\"step4\">Step 4: Add a Line to the Chart<\/h3>\n<p>Under the <strong>Customize<\/strong> tab, assign one data series to be represented as a line. This helps distinguish it from the bar data visually.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2024\/11\/Add-line.jpg\" alt=\"Google Sheets combo chart 4\"><\/div>\n<h3 id=\"step5\">Step 5: You\u2019ve Created a Combo Graph<\/h3>\n<p>Your combo chart is now ready, combining both bar and line elements to present data in a versatile and insightful way.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2024\/11\/Final-Combo-Graph.jpg\" alt=\"Google Sheets combo chart 5\"><\/div>\n<h3 id=\"step6\">Step 6: Customize Your Combo Chart<\/h3>\n<p>Use the customization options to adjust the colors, labels, gridlines, and legends to match your preferences and improve readability.<\/p>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2024\/11\/Customize-Chart.jpg\" alt=\"Google Sheets combo chart 6\"><\/div>\n<ul>\n<li>\n<h4>Edit Style in the Chart<\/h4>\n<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2024\/11\/Customize-Chart-Style.jpg\" alt=\"Google Sheets combo chart 7\" width=\"300\"><\/div>\n<h2 id=\"how-to-make-google-sheets-combo-chart\">How to Create Combo Charts in Google Sheets?<\/h2>\n<p>We acknowledge that Google Sheets is one of the most-used\u00a0<a href=\"https:\/\/ppcexpo.com\/blog\/data-visualization-tools\" target=\"_blank\" rel=\"noopener\">data visualization tools<\/a>\u00a0by professionals and businesses worldwide. Besides, the spreadsheet app has been there for years, plus it\u2019s familiar to many.<\/p>\n<p><em>However, this does not mean you should settle for less.<\/em><\/p>\n<p>In other words, if your goal is to create insightful and easy-to-interpret charts, you\u2019ve got to think beyond the basic Combination Diagrams in Google Sheets.<\/p>\n<p>To access insightful and visually appealing Combination Charts in Google Sheets, install third-party apps (add-ons).<\/p>\n<p>There are thousands of add-ons created specifically for <a href=\"https:\/\/ppcexpo.com\/blog\/google-sheets-charts\" target=\"_blank\" rel=\"noopener\">Google Sheets charts<\/a>. To save you time, we\u2019ve tested hundreds and narrowed them down to one.<\/p>\n<p>ChartExpo ticks all the boxes for the following:<\/p>\n<ul>\n<li><strong>Ease of use<\/strong><\/li>\n<li><strong>Ease of access<\/strong><\/li>\n<li><strong>Number of intuitive and advanced charts available<\/strong><\/li>\n<li><strong>Affordability<\/strong><\/li>\n<\/ul>\n<p>If you aim to create a lean <a href=\"https:\/\/ppcexpo.com\/blog\/digital-dashboard\" target=\"_blank\" rel=\"noopener\">visualization dashboard<\/a> and extract insights into two different variables in your data, your go-to chart maker should be ChartExpo.<\/p>\n<p>In the coming section, you\u2019ll learn how to install ChartExpo add-in to access advanced Google Sheets Combo Charts.<\/p>\n<h3 id=\"collect-and-arrange-data\">Step 1: Arrange Data For Combo Chart<\/h3>\n<p><b><\/b>Let\u2019s visualize the data below using one of the many Combination Charts in ChartExpo (Double Axis Line and Bar Chart)<\/p>\n<table class=\"static\">\n<tbody>\n<tr>\n<td width=\"184\"><strong>Months<\/strong><\/td>\n<td width=\"168\"><strong>Revenue<\/strong><\/td>\n<td width=\"172\"><strong>Profit Margin<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"184\">Jan<\/td>\n<td width=\"168\">5,000<\/td>\n<td width=\"172\">5<\/td>\n<\/tr>\n<tr>\n<td width=\"184\">Feb<\/td>\n<td width=\"168\">2,500<\/td>\n<td width=\"172\">10<\/td>\n<\/tr>\n<tr>\n<td width=\"184\">Mar<\/td>\n<td width=\"168\">3,600<\/td>\n<td width=\"172\">7<\/td>\n<\/tr>\n<tr>\n<td width=\"184\">Apr<\/td>\n<td width=\"168\">3,250<\/td>\n<td width=\"172\">14<\/td>\n<\/tr>\n<tr>\n<td width=\"184\">May<\/td>\n<td width=\"168\">1,975<\/td>\n<td width=\"172\">19<\/td>\n<\/tr>\n<tr>\n<td width=\"184\">Jun<\/td>\n<td width=\"168\">1,874<\/td>\n<td width=\"172\">20<\/td>\n<\/tr>\n<tr>\n<td width=\"184\">Jul<\/td>\n<td width=\"168\">3,952<\/td>\n<td width=\"172\">6<\/td>\n<\/tr>\n<tr>\n<td width=\"184\">Aug<\/td>\n<td width=\"168\">2,222<\/td>\n<td width=\"172\">9<\/td>\n<\/tr>\n<tr>\n<td width=\"184\">Sep<\/td>\n<td width=\"168\">4,260<\/td>\n<td width=\"172\">4<\/td>\n<\/tr>\n<tr>\n<td width=\"184\">Oct<\/td>\n<td width=\"168\">3,300<\/td>\n<td width=\"172\">22<\/td>\n<\/tr>\n<tr>\n<td width=\"184\">Nov<\/td>\n<td width=\"168\">1,500<\/td>\n<td width=\"172\">17<\/td>\n<\/tr>\n<tr>\n<td width=\"184\">Dec<\/td>\n<td width=\"168\">1,160<\/td>\n<td width=\"172\">9<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ul>\n<li>To visualize the data (above) using Combo Charts, copy and paste it into your Google Sheets.<\/li>\n<\/ul>\n<h3 id=\"install-chartexpo\">Step 2: Install ChartExpo Add-In<\/h3>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2022\/08\/google-sheets-combo-chart-1.jpg\" alt=\"Google Sheets combo chart\"><\/div>\n<ul>\n<li>Head to the\u00a0<strong>Add-on button&gt;ChartExpo \u2014 Best Data Visualization Tool button&gt;Open.<br \/>\n<\/strong><\/li>\n<\/ul>\n<h3 id=\"add-new-chart\">Step 3: Click the Add New Chart<\/h3>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2022\/08\/google-sheets-combo-chart-2.jpg\" alt=\"Google Sheets combo chart\"><\/div>\n<ul>\n<li>Click the\u00a0<strong>Add New Chart <\/strong>button\u00a0to access your fully stocked library of charts.<\/li>\n<\/ul>\n<h3 id=\"select-chart\">Step 4: Select Combo Chart<\/h3>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2022\/08\/google-sheets-combo-chart-3.jpg\" alt=\"Google Sheets combo chart\"><\/div>\n<ul>\n<li>Click\u00a0<strong>the Search Box<\/strong>\u00a0and type \u201c<strong>Double Axis Line and Bar Chart.\u201d<\/strong>\u00a0It should pop up together with other charts.<\/li>\n<li>Select the sheet holding your data and select the\u00a0<strong>Metrics option.\u00a0<\/strong>Fill in the numerical numbers (in our scenario, we\u2019ll fill in\u00a0<strong>revenue and profit margin<\/strong>)<\/li>\n<li>Select the\u00a0<strong>Dimensions button<\/strong>\u00a0and fill in the dimensional data (in our example, we\u2019ll use\u00a0<strong>months<\/strong>)<\/li>\n<li>How to make Google Sheets Combo Chart does not have to be complex. ChartExpo makes the whole process seamless and easy.<\/li>\n<\/ul>\n<h3 id=\"edit-chart\">Step 5: Edit And Create Chart Button<\/h3>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2022\/08\/google-sheets-combo-chart-4.jpg\" alt=\"Google Sheets combo chart\"><\/div>\n<ul>\n<li>Finish the simple process by clicking the\u00a0<strong>Create Chart button<\/strong>.<\/li>\n<li>If you follow the instructions (above), your Progress Chart should look like this (below).<\/li>\n<\/ul>\n<h3 id=\"final-chart\">Step 6: Final Combo Chart Below<\/h3>\n<div style=\"text-align: center;\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/google-sheets-combo-chart-5.jpg\" alt=\"Google Sheets combo chart\"><\/div>\n<div style=\"text-align: center;\">Source:chartexpo.com<\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZytncytwcGMrNjE5Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/google-sheets-combo-chart-button-3.jpg\" alt=\"Google Sheets combo chart\"><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTArYmxvZyt4bCtwcGMrNjE5Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/ppcexpo.com\/blog\/wp-content\/uploads\/2021\/12\/google-sheets-combo-chart-button-4.jpg\" alt=\"Google Sheets combo chart\"><\/a><\/div>\n<h4>Insights<\/h4>\n<ul>\n<li>The profit margin was sky-high in January and almost rock bottom in December.<\/li>\n<li>October had the highest revenue.<\/li>\n<li>September had the lowest revenue during the financial year.<\/li>\n<li>Profit margin in May and June was low despite high revenues.<\/li>\n<\/ul>\n<h2 id=\"google-sheets-combo-chart-faqs\">How to Create a Combo Chart in Google Sheets: FAQs<\/h2>\n<h3>Can I create a Combo Chart using pivot table data?<\/h3>\n<p>Yes, you can create a Combo Chart using pivot table data. First, create the pivot table, then select the pivot table range and insert a Combo Chart.<\/p>\n<h3>Can I use a Combo Chart to display stacked bars and lines?<\/h3>\n<p>Yes, you can create stacked bars and lines in a Combo Chart by setting one series to a stacked bar and another to a line.<\/p>\n<h3>How do I make a Combo Chart show only the most recent data?<\/h3>\n<p>Filter the data range to include only the most recent data points, or use a dynamic range that updates based on the most recent entries.<\/p>\n<h4 id=\"wrap-up\">Wrap Up<\/h4>\n<p>Visualizing complex data with varying metrics should never be a nerve-wracking or time-consuming affair.\u00a0<em>Yes, you read that right.<\/em><\/p>\n<p>It turns out there\u2019s a visualization design called Google Sheets Combo Chart that\u2019s best suited for the job (above).\u00a0<em>Why?<\/em><\/p>\n<p>The Combination Graph can help you save a ton of space in your dashboard by displaying varying variables in your data within a single chart.<\/p>\n<p>We recommend you avoid over-relying on Google Sheets, especially if your goal is to create simple-to-interpret charts.<\/p>\n<p><em>Why?<\/em><\/p>\n<p>Google Sheets Combo Charts are very basic and require a lot of effort and time to edit. But we\u2019re not recommending you to do away with the freemium spreadsheet application.<\/p>\n<p>We recommend installing third-party applications (add-ons), such as ChartExpo, into your Google Sheets to access advanced Combo Charts.<\/p>\n<p>ChartExpo is an add-on you can easily download and install in your Google Sheets. Besides, this tool comes loaded with insightful and easy-to-interpret Combination Charts, plus over 50 more advanced charts.<\/p>\n<p>You don\u2019t need programming or coding skills to visualize your data with the ChartExpo add-on.<\/p>\n<p>Sign up for a 7-day free trial today to access easy-to-interpret and visually appealing Combo Visualization Designs.<\/p>\n","protected":false},"excerpt":{"rendered":"<p><p>Learn how to create and use Google Sheets Combo Charts for effective data visualization with step-by-step instructions.<\/p>\n&nbsp;&nbsp;<a href=\"https:\/\/ppcexpo.com\/blog\/google-sheets-combo-chart\"><\/a><\/p>","protected":false},"author":1,"featured_media":38946,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[887],"tags":[875],"_links":{"self":[{"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/posts\/20426"}],"collection":[{"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/comments?post=20426"}],"version-history":[{"count":14,"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/posts\/20426\/revisions"}],"predecessor-version":[{"id":45787,"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/posts\/20426\/revisions\/45787"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/media\/38946"}],"wp:attachment":[{"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/media?parent=20426"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/categories?post=20426"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ppcexpo.com\/blog\/wp-json\/wp\/v2\/tags?post=20426"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}