How to Create a Combo Chart in Google Sheets

In this tutorial, you will learn how to create a combo chart in Google Sheets.

How to Create a Combo Chart in Google Sheets

The combination chart combines the properties of a bar chart and a line chart into one visualization. The data is represented in the combination chart by a number of bars and/or lines, each of which represents a different category.

When comparing numbers in different categories, combining bars and lines in the same picture can be advantageous because it makes it clear whether the category is higher or lower.

For example, we can utilize the combo chart to compare anticipated and actual sales over different time periods.

A combo chart is a smart and intelligent way to present data, however, they’re usually reserved for column and line combinations. They aren’t appropriate in all circumstances. A pie chart, for example, would be a better way to visualize parts-to-whole.

Let’s use the earlier mentioned example to make a combo chart in Google Sheets together!

Creating a Combo Chart

Before we begin we will need a group of data to be used to create the combo chart.

Step 1 – Group your data

Make sure your group of data is displayed in a clean and tidy manner. This will help us to create the combo chart easily.

Untitled

Step 2 – Select data & insert chart

Select the entire data cell, choose Insert, and select Chart.

Untitled

Step 3 – Change to combo chart

By default, Google Sheet will use the selected group of data to generate a line chart.

To change it to a combo chart, we will need to change it at the Chart Type.

Untitled

Step 4 – Customize chart

Now, you can customize the combo chart to your preference. We will change the chart title to ‘Actual Revenue vs Budgeted Revenue’ for a better representation of the combo chart.

Also, to emphasize the chart title, we will change the text color to black, bold it, and also align it to the center.

Untitled

Step 5 – Am I the only one hungry, thinking of combo meals…?

Once you are done editing and customizing the combo chart, it will look something like this:

Untitled

With a combo chart, you can see whether the budget calculations for revenue are accurate or not.

Summary

That’s all there is to it. You are welcome to copy the example spreadsheet below to see how it is done. The most crucial lesson is to enjoy yourself while doing it.

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to make categories in google sheets. Want more? Check out all the Google Sheets Tutorials.