Line charts in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a line chart from data in cells A1 to B5.

Google Sheets

=SPARKLINE(A1:B5, {"charttype", [1])

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

A"line"

Bscatter

Cpie

Dbar

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'bar' or 'pie' instead of 'line' for the chart type.

Forgetting to put the chart type inside quotes.

The SPARKLINE function with "charttype" set to "line" creates a line chart.

2fill in blank

medium

Complete the code to set the line width to 2 for the line chart.

Google Sheets

=SPARKLINE(A1:B5, {"charttype", "line", "[1]", 2})

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

Acolor

Blegend

Clinewidth

Daxis

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'color' or 'legend' instead of 'linewidth'.

Not placing the linewidth option inside the options array.

The "linewidth" option sets the thickness of the line in the sparkline.

3fill in blank

hard

Fix the error in the formula to correctly set the line color to blue.

Google Sheets

=SPARKLINE(A1:B5, {"charttype", "line", "color", [1])

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

ABlue

Bblue

C'blue'

D"blue"

Attempts:

3 left

💡 Hint

Common Mistakes

Using color names without quotes.

Using single quotes instead of double quotes.

Colors must be given as text strings inside double quotes, like "blue".

4fill in blank

hard

Fill both blanks to create a line chart with a red line.

Google Sheets

=SPARKLINE(A1:B5, {"charttype", [1], "color", [2])

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

A"line"

B"red"

C"blue"

Dbar

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'bar' instead of 'line' for the chart type.

Not putting the color name in quotes.

Use "line" for the chart type and "red" (in quotes) for the color.

5fill in blank

hard

Fill all three blanks to create a line chart with green color and line width of 3.

Google Sheets

=SPARKLINE(A1:B5, {"charttype", [1], "color", [2], "linewidth", [3])

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

A"line"

B"green"

C3

D"blue"

Attempts:

3 left

💡 Hint

Common Mistakes

Using quotes around the line width number.

Using wrong color names or missing quotes.

Use "line" for chart type, "green" for color, and 3 for line width.