0
0
Google Sheetsspreadsheet~10 mins

Sparklines (LINE, BAR, COLUMN) in Google Sheets - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

Monthly sales data for two products from January to May.

CellValue
A1Jan
B1Feb
C1Mar
D1Apr
E1May
A210
B215
C220
D225
E230
A35
B37
C39
D36
E38
Formula Trace
=SPARKLINE(A2:E2, {"charttype", "line"})
Step 1: SPARKLINE({10,15,20,25,30}, {"charttype", "line"})
Cell Reference Map
     A      B      C      D      E      F
1 | Jan | Feb | Mar | Apr | May |     |
2 | 10  | 15  | 20  | 25  | 30  |     | <-- Values used for sparkline
3 | 5   | 7   | 9   | 6   | 8   |     |
The sparkline formula references cells A2 to E2 which contain the first product's monthly sales.
Result
     A      B      C      D      E      F
1 | Jan | Feb | Mar | Apr | May |     |
2 | 10  | 15  | 20  | 25  | 30  |▁▃▄▆█ |  <-- Sparkline line chart representing sales trend
3 | 5   | 7   | 9   | 6   | 8   |     |
Cell F2 shows a small line sparkline graph representing the sales trend from January to May. The line rises as values increase.
Sheet Trace Quiz - 3 Questions
Test your understanding
What does the SPARKLINE function do with the range A2:E2?
AShows the highest number only
BAdds all the numbers together
CCreates a small line chart showing the trend of the numbers
DReplaces numbers with text labels
Key Result
SPARKLINE(range, {"charttype", "type"}) creates a mini chart inside a cell showing data trends.