Chart editor panel in Google Sheets - Cell-by-Cell Formula Trace

Sample Data

Monthly sales data for the first four months of the year.

Cell	Value
A1	Month
B1	Sales
A2	Jan
B2	100
A3	Feb
B3	150
A4	Mar
B4	130
A5	Apr
B5	170

Formula Trace

No formula used; chart created using Chart editor panel selecting range A1:B5

Step 1: Select range A1:B5

Step 2: Open Chart editor panel

Step 3: Choose chart type: Column chart

Step 4: Chart editor auto assigns X-axis to A1:A5 (Month) and Series to B1:B5 (Sales)

Step 5: Customize chart title to 'Monthly Sales'

Cell Reference Map

    A       B
1 |Month | Sales |
2 | Jan  | 100  |
3 | Feb  | 150  |
4 | Mar  | 130  |
5 | Apr  | 170  |

Range A1:B5 is selected for chart data.

The chart uses the data range A1:B5, where column A is the X-axis (months) and column B is the Y-axis (sales).

Result

Spreadsheet view:

    A       B
1 |Month | Sales |
2 | Jan  | 100  |
3 | Feb  | 150  |
4 | Mar  | 130  |
5 | Apr  | 170  |

Chart view (Column chart):

|   |   |   |   |
|   |   |   |   |
|   |   |   |   |
|   |   |   |   |
|___|___|___|___|
 Jan Feb Mar Apr

Columns heights correspond to sales values: 100, 150, 130, 170

The chart shows a column for each month with height proportional to sales. The title 'Monthly Sales' is displayed above.

Sheet Trace Quiz - 3 Questions

Which cells are selected to create the chart?

A A2:B5

B B1:B5

C A1:B5

D A1:A5

Key Result

Chart editor panel uses selected cell range to create charts by assigning X-axis and series automatically.