Embedding charts in Docs and Slides 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	130

Formula Trace

CHART(A1:B4, "ColumnChart")

Step 1: Select data range A1:B4

Step 2: Create ColumnChart using selected data

Step 3: Embed chart into Google Docs or Slides

Cell Reference Map

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

Data range A1:B4 is used to create the chart.

The chart uses the data from cells A1 to B4, including headers and sales figures.

Result

Google Docs or Slides document:

+-----------------------------+
|        Sales Chart          |
|  Jan |■■■■■■■■■■            |
|  Feb |■■■■■■■■■■■■■■■■       |
|  Mar |■■■■■■■■■■■■           |
+-----------------------------+

The chart shows sales bars for Jan, Feb, and Mar.

The embedded chart visually represents the sales data as vertical bars in the document or slide.

Sheet Trace Quiz - 3 Questions

Which cells are included in the data range for the chart?

A A2:B4

B A1:B4

C B1:B4

D A1:A4

Key Result

Select data range and specify chart type to create and embed a linked chart in Docs or Slides.