Chart customization (title, legend, colors) in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to set the chart title to "Sales Report".

Google Sheets

chart.setOption('title', [1]);

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

Atitle

BSales Report

C'Sales Report'

D"Sales Report"

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting to put quotes around the title text

Using a variable name instead of a string

The chart title must be a string enclosed in double quotes. Option D correctly uses double quotes around the title text.

2fill in blank

medium

Complete the code to show the chart legend at the bottom.

Google Sheets

chart.setOption('legend', { position: [1] });

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

A"bottom"

B"top"

C"left"

D"right"

Attempts:

3 left

💡 Hint

Common Mistakes

Using position without quotes

Choosing the wrong position value

The legend position must be set as a string. "bottom" places the legend below the chart.

3fill in blank

hard

Fix the error in the code to set the first series color to red.

Google Sheets

chart.setOption('colors', [[1]]);

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

Ared

B'red'

C"red"

DcolorRed

Attempts:

3 left

💡 Hint

Common Mistakes

Using color names without quotes

Using undefined variables for colors

Colors must be strings inside quotes. Option C correctly uses double quotes around "red".

4fill in blank

hard

Fill both blanks to set the chart title to "Monthly Sales" and place the legend on the right.

Google Sheets

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

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

A"Monthly Sales"

B"bottom"

C"right"

D"Monthly"

Attempts:

3 left

💡 Hint

Common Mistakes

Using partial title text

Wrong legend position value

The title must be a string with quotes, and the legend position must be "right" to place it on the right side.

5fill in blank

hard

Fill all three blanks to set the chart title to "Annual Revenue", legend at the top, and colors to blue and green.

Google Sheets

chart.setOption('title', [1]);
chart.setOption('legend', { position: [2] });
chart.setOption('colors', [[3]]);

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

A"Annual Revenue"

B"top"

C"blue", "green"

D"bottom"

Attempts:

3 left

💡 Hint

Common Mistakes

Not quoting strings

Putting colors as a single string instead of separate quoted strings

The title is "Annual Revenue" in quotes, the legend position is "top", and colors are an array of strings "blue" and "green".