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".

Practice

1. What is the main purpose of adding a title to a chart in Google Sheets?

easy

A. To add more data points to the chart

B. To change the chart's data range

C. To explain what the chart is about quickly

D. To delete the chart from the sheet

Solution

1. Step 1: Understand chart titles

   A chart title gives a quick explanation of what the chart shows.

2. Step 2: Identify the purpose of a title

   It helps viewers understand the chart's message without guessing.

3. Final Answer:

   To explain what the chart is about quickly -> Option C

4. Quick Check:

   Chart title = Explanation [OK]

Hint: Titles explain charts quickly; legends and colors clarify details [OK]

Common Mistakes:

• Thinking titles change data
• Confusing titles with legends
• Assuming titles add data points

2. Which step correctly changes the legend position in Google Sheets chart editor?

easy

A. Go to Customize tab, then Legend, and select position

B. Go to Setup tab, then Data range, and select legend

C. Right-click chart and choose Delete legend

D. Double-click chart title and type legend position

Solution

1. Step 1: Locate legend settings

   Legend position is changed under the Customize tab in the Chart Editor.

2. Step 2: Select the Legend section

   Inside Customize, click Legend to find position options.

3. Final Answer:

   Go to Customize tab, then Legend, and select position -> Option A

4. Quick Check:

   Legend position = Customize > Legend [OK]

Hint: Legend settings are always under Customize tab [OK]

Common Mistakes:

• Looking for legend in Setup tab
• Trying to edit legend by deleting it
• Changing title instead of legend

3. You created a pie chart in Google Sheets. You want to change the slice colors to red, blue, and green. Where do you do this?

medium

A. Data tab > Color palette > Choose colors

B. Setup tab > Chart type > Select colors

C. Insert tab > Chart colors > Pick colors

D. Customize tab > Series > Change slice colors

Solution

1. Step 1: Open Customize tab in Chart Editor

   Colors for slices are changed under Customize, not Setup or Data tabs.

2. Step 2: Select Series section

   Series controls the colors of chart elements like slices.

3. Final Answer:

   Customize tab > Series > Change slice colors -> Option D

4. Quick Check:

   Slice colors = Customize > Series [OK]

Hint: Change colors in Customize > Series for pie charts [OK]

Common Mistakes:

• Trying to change colors in Setup tab
• Looking for colors in Data tab
• Searching Insert tab for colors

4. You tried to change the chart title by typing directly on the chart, but it didn't work. What is the correct way to edit the chart title?

medium

A. Use the Customize tab, then Chart & axis titles, and edit the Title text

B. Double-click the legend and type the new title

C. Change the data range to update the title automatically

D. Right-click the chart and select Delete title, then add a new one

Solution

1. Step 1: Locate title editing in Customize tab

   Chart titles are edited under Customize > Chart & axis titles.

2. Step 2: Edit the Title text field

   Change the text in the Title box to update the chart title.

3. Final Answer:

   Use the Customize tab, then Chart & axis titles, and edit the Title text -> Option A

4. Quick Check:

   Title edit = Customize > Chart & axis titles [OK]

Hint: Edit titles only in Customize > Chart & axis titles [OK]

Common Mistakes:

• Trying to edit title by double-clicking legend
• Changing data range to affect title
• Deleting title instead of editing

5. You have a bar chart showing sales for three products. You want the legend to appear at the bottom, the title to say "Monthly Sales", and each bar to have a different color: red, yellow, and blue. Which steps correctly achieve this?

hard

A. Setup tab > Chart title > Type title; Setup > Legend > Position bottom; Setup > Colors > Pick colors

B. Customize tab > Chart & axis titles > Set title; Customize > Legend > Position bottom; Customize > Series > Set colors for each bar

C. Right-click chart > Edit title; Right-click legend > Move bottom; Double-click bars > Change colors

D. Insert tab > Add title; Insert > Legend > Bottom; Insert > Colors > Select colors

Solution

1. Step 1: Set the chart title in Customize > Chart & axis titles

   This is where you type "Monthly Sales" as the chart title.

2. Step 2: Move the legend to the bottom in Customize > Legend

   Select the position option to place the legend below the chart.

3. Step 3: Change bar colors in Customize > Series

   Assign red, yellow, and blue colors to each product bar here.

4. Final Answer:

   Customize tab > Chart & axis titles > Set title; Customize > Legend > Position bottom; Customize > Series > Set colors for each bar -> Option B

5. Quick Check:

   Title, legend, colors = Customize tab [OK]

Hint: All chart customizations happen in Customize tab [OK]

Common Mistakes:

• Trying to set title or legend in Setup tab
• Right-clicking chart elements to edit
• Using Insert tab for chart customization