Combo charts in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a combo chart with a line and a column series.

Google Sheets

chart = sheet.newChart().setChartType(Charts.ChartType.[1]).addRange(dataRange).build()

Drag options to blanks, or click blank then click option'

ACOLUMN

BLINE

CCOMBO

DPIE

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing only LINE or COLUMN chart types instead of COMBO.

Using PIE chart type which does not combine series.

The combo chart type is COMBO in Google Sheets scripting to combine line and column charts.

2fill in blank

medium

Complete the code to set the first series as a column and the second series as a line in the combo chart.

Google Sheets

chart = chart.modify().setOption('series', {0: {type: '[1]'}, 1: {type: '[2]'}}).build()

Drag options to blanks, or click blank then click option'

Aline

Bcolumn

Cpie

Dbar

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping the series types.

Using unsupported chart types like pie or bar here.

In combo charts, you specify each series type. The first series is column, the second is line.

3fill in blank

hard

Fix the error in the code to correctly set the combo chart's vertical axes for each series.

Google Sheets

chart = chart.modify().setOption('vAxes', {0: {title: 'Sales'}, 1: {title: 'Profit', [1]: true}}).build()

Drag options to blanks, or click blank then click option'

Alogarithmic

BlogScale

CisLogScale

Dlog_axis

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect property names like isLogScale or logarithmic.

Misspelling the property name.

The correct option to enable logarithmic scale on vertical axes is logScale.

4fill in blank

hard

Fill both blanks to set the combo chart's title and legend position.

Google Sheets

chart = chart.modify().setOption('title', '[1]').setOption('legend', {position: '[2]'}).build()

Drag options to blanks, or click blank then click option'

AMonthly Sales Report

BAnnual Profit Overview

Cright

Dbottom

Attempts:

3 left

💡 Hint

Common Mistakes

Using a title that doesn't match the data context.

Setting legend position to unsupported values.

The chart title is set to Monthly Sales Report and the legend position to bottom for clarity.

5fill in blank

hard

Fill all three blanks to create a combo chart with a column series, a line series, and set the second vertical axis title.

Google Sheets

chart = sheet.newChart().setChartType(Charts.ChartType.[1]).addRange(dataRange).setOption('series', {0: {type: '[2]'}, 1: {type: '[3]'}}).setOption('vAxes', {1: {title: 'Profit Margin'}}).build()

Drag options to blanks, or click blank then click option'

ACOMBO

Bcolumn

Cline

Dbar

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong chart type or series types.

Forgetting to set the vertical axis title.

The combo chart type is COMBO. The first series is column, the second is line. The second vertical axis is titled 'Profit Margin'.