Chart customization (title, legend, colors) in Google Sheets - Cell-by-Cell Formula Trace

Sample Data

Monthly sales data for the first quarter

Cell	Value
A1	Month
B1	Sales
A2	Jan
B2	100
A3	Feb
B3	150
A4	Mar
B4	120

Formula Trace

CHART(A1:B4, {"title": "Quarter 1 Sales", "legend": "right", "colors": ["#1a73e8"]})

Step 1: Data range selected: A1:B4

Step 2: Chart title set to 'Quarter 1 Sales'

Step 3: Legend position set to 'right'

Step 4: Chart colors set to ['#1a73e8']

Step 5: Chart rendered with data, title, legend, and colors

Cell Reference Map

Month

↓

Jan

↓

Feb

↓

Mar

The chart uses the data range from cells A1 to B4 including headers and sales values.

Result

Spreadsheet view:

  A       B
1 Month   Sales
2 Jan     100
3 Feb     150
4 Mar     120

Chart area:
+---------------------------+
| Quarter 1 Sales           |
|                           |
| 150 ┤          ●           |
| 120 ┤      ●              |
| 100 ┤  ●                  |
|      └────────────────────┘
| Legend: Sales (blue)       |
+---------------------------+

The chart shows sales for Jan, Feb, and Mar with a blue line or bars. The title 'Quarter 1 Sales' is on top. The legend is on the right side, explaining the blue color represents sales.

Sheet Trace Quiz - 3 Questions

What data range is used to create the chart?

A A1:B3

B A1:B4

C A2:B4

D B1:B4

Key Result

CHART function uses a data range and customization options like title, legend position, and colors to create a chart.