Sparklines (LINE, BAR, COLUMN) in Google Sheets - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales analyst at a retail company.

📋 Request: Your manager wants a quick visual summary of monthly sales trends for each product using sparklines.

📊 Data: You have monthly sales data for 6 products over 6 months in a table.

🎯 Deliverable: Create sparklines (line, bar, and column) next to each product row to show sales trends visually.

Sample Data

Product	Jan	Feb	Mar	Apr	May	Jun
Apples	120	135	150	160	170	180
Bananas	80	90	85	95	100	110
Cherries	60	65	70	75	80	85
Dates	40	45	50	55	60	65
Elderberries	30	35	40	45	50	55
Figs	20	25	30	35	40	45

1

Step 1: Select the cell next to the first product row to insert a line sparkline showing sales trend from Jan to Jun.

=SPARKLINE(B2:G2, {"charttype", "line"})

Expected Result

A small line chart appears showing increasing sales trend for Apples.

2

Step 2: Copy the line sparkline formula down for all product rows to show line sparklines for each product.

Copy formula from step 1 down to rows 3 to 7.

Expected Result

Each product row shows a line sparkline reflecting its monthly sales trend.

3

Step 3: In the next column, insert a bar sparkline for the first product row showing sales from Jan to Jun.

=SPARKLINE(B2:G2, {"charttype", "bar"})

Expected Result

A small horizontal bar chart appears showing sales amounts for Apples.

4

Step 4: Copy the bar sparkline formula down for all product rows.

Copy formula from step 3 down to rows 3 to 7.

Expected Result

Each product row shows a bar sparkline reflecting monthly sales amounts.

5

Step 5: In the next column, insert a column sparkline for the first product row showing sales from Jan to Jun.

=SPARKLINE(B2:G2, {"charttype", "column"})

Expected Result

A small vertical column chart appears showing sales amounts for Apples.

6

Step 6: Copy the column sparkline formula down for all product rows.

Copy formula from step 5 down to rows 3 to 7.

Expected Result

Each product row shows a column sparkline reflecting monthly sales amounts.

Final Result

Product     Jan  Feb  Mar  Apr  May  Jun  Line Sparkline  Bar Sparkline  Column Sparkline
Apples      120  135  150  160  170  180  ───▁▂▃▄▅▆▇█    ▉▊▋▌▍▎▏      ▂▃▄▅▆▇█
Bananas      80   90   85   95  100  110  ▂▃▂▄▅▆▇█      ▅▆▅▇▇▉▉      ▃▄▅▅▆▇▉
Cherries     60   65   70   75   80   85  ▁▂▃▄▅▆▇█      ▂▃▅▆▇▉▉      ▂▃▄▅▆▇█
Dates        40   45   50   55   60   65  ▁▂▃▄▅▆▇█      ▂▃▅▆▇▉▉      ▂▃▄▅▆▇█
Elderberries 30   35   40   45   50   55  ▁▂▃▄▅▆▇█      ▂▃▅▆▇▉▉      ▂▃▄▅▆▇█
Figs         20   25   30   35   40   45  ▁▂▃▄▅▆▇█      ▂▃▅▆▇▉▉      ▂▃▄▅▆▇█

✓Line sparklines show steady growth in sales for all products over 6 months.

✓Bar sparklines highlight the relative sales amounts each month for each product.

✓Column sparklines provide a vertical visual comparison of monthly sales trends.

Bonus Challenge

Add color to the sparklines to highlight months with sales above 150 in line sparklines.

Show Hint

Use the 'color' option in SPARKLINE formula with an IF condition to change color based on sales values.