How to Create a Combo Chart in Google Sheets (Step-by-Step)

A combo chart is a type of chart that uses bars and lines to display two different datasets in a single plot.

combo chart in Google Sheets

The following step-by-step example shows how to create a combo chart in Google Sheets.

Step 1: Enter Data

First, let’s enter some data for the total sales and total new clients signed for a certain company during a 12-month period:

Step 2: Create Combo Chart

To create a combo chart to visualize this data, we can highlight the cells in the range A1:C13 and then click Insert and then click Chart:

A line chart with two lines will automatically appear.

To turn this into a combo chart, click anywhere on the chart and then click on the three vertical dots in the top right corner, then click Edit:

In the Chart editor panel that appears on the right side of the screen, click the Chart type dropdown menu, then click Combo chart:

The chart will automatically be converted into a combo chart:

The x-axis displays the month, the bars display the total sales by month, and the line displays the total new clients signed by month.

Step 3: Modify the Combo Chart

Feel free to click on individual elements in the chart to modify their appearance.

For example, we can change the title, the colors of the bars and lines, and the location of the legend:

combo chart in Google Sheets

Additional Resources

The following tutorials explain how to create other common visualizations in Google Sheets:

How to Create a Box Plot in Google Sheets
How to Create a Pie Chart in Google Sheets
How to Create a Bubble Chart in Google Sheets
How to Create a Stacked Bar Chart in Google Sheets

Leave a Reply

Your email address will not be published. Required fields are marked *