A combo chart is a type of chart that uses bars and lines to display two different datasets in a single plot.
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:
The following tutorials explain how to create other common visualizations in Google Sheets: