Combo charts in Google Sheets - Cell-by-Cell Formula Trace

Sample Data

Monthly sales and profit data for three months.

Cell	Value
A1	Month
B1	Sales
C1	Profit
A2	Jan
B2	1000
C2	200
A3	Feb
B3	1500
C3	300
A4	Mar
B4	1200
C4	250

Formula Trace

Chart: Combo chart with Sales as columns and Profit as line

Step 1: Select data range A1:C4

Step 2: Insert chart and choose Combo chart type

Step 3: Set Sales series to Column chart

Step 4: Set Profit series to Line chart

Step 5: Adjust axes if needed (e.g., Profit on secondary axis)

Cell Reference Map

    A       B       C  
1 | Month | Sales | Profit |
2 |  Jan  | 1000  |  200   |
3 |  Feb  | 1500  |  300   |
4 |  Mar  | 1200  |  250   |

The chart uses data from columns A (Month), B (Sales), and C (Profit).

Result

Combo Chart:

|  Sales (Columns)  |
|  |  |  |          |
|  |  |  |          |
|  |  |  |          |
|__|__|__|__|__|__|__|
 Jan Feb Mar

Profit (Line) overlays the columns showing trend.

The combo chart shows Sales as columns and Profit as a line over the months Jan, Feb, and Mar.

Sheet Trace Quiz - 3 Questions

Which data column is shown as columns in the combo chart?

A Sales

B Profit

C Month

D None

Key Result

Combo charts combine multiple chart types by assigning each data series a chart style and optionally a secondary axis.