Sparklines (LINE, BAR, COLUMN) in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a simple line sparkline for data in cells A1 to A5.

Google Sheets

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

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

A"line"

B"bar"

C"column"

D"pie"

Attempts:

3 left

💡 Hint

Common Mistakes

Using "bar" or "column" instead of "line" for a line sparkline.

Forgetting the quotes around the chart type.

The charttype option set to "line" creates a line sparkline.

2fill in blank

medium

Complete the code to create a bar sparkline for data in cells B1 to B6.

Google Sheets

=SPARKLINE(B1:B6, {"charttype", [1])

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

A"scatter"

B"line"

C"column"

D"bar"

Attempts:

3 left

💡 Hint

Common Mistakes

Using "line" or "column" instead of "bar".

Missing quotes around the chart type.

Setting charttype to "bar" creates a bar sparkline.

3fill in blank

hard

Fix the error in the code to create a column sparkline for data in cells C1 to C7.

Google Sheets

=SPARKLINE(C1:C7, {"charttype", [1])

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

A"column"

B"line"

C"area"

D"bar"

Attempts:

3 left

💡 Hint

Common Mistakes

Using "bar" which creates horizontal bars instead of vertical.

Using unsupported chart types like "area".

The correct chart type for vertical bars is "column".

4fill in blank

hard

Fill both blanks to create a line sparkline with a red line color for data in D1 to D5.

Google Sheets

=SPARKLINE(D1:D5, {"charttype", [1]; "color", [2])

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

A"line"

B"bar"

C"red"

D"blue"

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up chart type and color options.

Using color names without quotes.

Use "line" for the chart type and "red" for the color option.

5fill in blank

hard

Fill all three blanks to create a column sparkline with green bars and a max value of 100 for data in E1 to E8.

Google Sheets

=SPARKLINE(E1:E8, {"charttype", [1]; "color", [2]; "max", [3])

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

A"column"

B"green"

C100

D"yellow"

Attempts:

3 left

💡 Hint

Common Mistakes

Putting quotes around the number 100.

Using wrong chart type or color.

Set charttype to "column", color to "green", and max to 100.