8.11 Sparklines
In short: Sparklines are tiny charts inside a cell – perfect next to a table row.
Sparklines are tiny charts inside a cell – perfect next to a table row.
Steps in Excel
- Select the empty cells where sparklines go (e.g. F2:F4 next to each city's six months).
- Insert › Sparklines › Line (or Column, Win/Loss) › Data Range
B2:E4-style range of values › OK. - Sparkline tab › tick High Point and Low Point; choose a style.
- Sparkline › Group › Axis › Same for All Sparklines when you want to compare levels across rows.
Worked example. City summary table with a line sparkline for Jul–Dec per city; the markers show every city peaking in Nov.
Ravindra Bagale's Tip
Each sparkline has its own axis – so even a small change in a small city looks big. Many students draw the wrong conclusion: "Kolhapur grew as much as Pune". If you want to compare, set Axis › Same for All Sparklines.
Ravindra Bagale's Tip – मराठी
प्रत्येक sparkline चा axis वेगळा असतो – लहान city चा लहान बदल पण मोठा दिसतो. बरेच students "Kolhapur पण Pune एवढाच वाढला" असा चुकीचा निष्कर्ष काढतात. Compare करायचं असेल तर Axis › Same for All Sparklines करा.
Ravindra Bagale's Tip – हिंदी
हर sparkline का axis अलग होता है – छोटी city का छोटा बदलाव भी बड़ा दिखता है. बहुत से students गलत नतीजा निकालते हैं कि "Kolhapur भी Pune जितना ही बढ़ा". Compare करना हो तो Axis › Same for All Sparklines करो.
Worked example — sparklines
Why
Aamir Khan in Pune and Yuki Tanaka abroad both need a clear, repeatable way to use sparklines on a HomeNest Supplies sheet without breaking totals.
What
Sparklines is the Excel idea this page teaches. We will walk one tiny example end to end.
How
- Open a blank sheet. In A1 type a short label for sparklines.
- Enter a small made-up value for Aamir Khan using € where money appears.
- Add a second value for Yuki Tanaka using ₹ so you see mixed currencies stay numeric.
- Apply the method from this lesson step by step (menu or formula as shown above).
- Check the result still works inside SUM or a simple check cell.
Formula / action
Follow the formula or ribbon steps shown in this lesson (keep values numeric).Meaning: Once sparklines is correct on one row, copy the same pattern down the column.
Practice tasks (10+)
Try these on a blank sheet. Open a hint only if you are stuck. No quiz — just practice.
1. Rebuild the smallest example of sparklines on a blank sheet for FreshGo Mart.
Hint: Use only the steps on this page. Keep numbers numeric.
2. Change one input for Aamir Khan and confirm the result updates.
Hint: If the result is stuck, check absolute vs relative references.
3. Repeat the same steps with a £ or € value for James O'Neill.
Hint: Formatting must not break SUM.
4. Write the result meaning in one plain sentence next to the cell.
Hint: Imagine explaining it to a new joiners.
5. Add a second row and fill the method down.
Hint: Double-click the fill handle if the pattern is consistent.
6. Break the example on purpose, then fix it using this lesson.
Hint: Common break: text instead of a number.
7. Apply sparklines to a 5-row made-up FreshGo Mart table.
Hint: Keep column headers clear.
8. Check your answer with a simple total or COUNT.
Hint: A wrong total usually means a format or key mismatch.
9. Swap ₹ and $ on one column and re-check totals.
Hint: Stored values stay the same; only the display changes.
10. List two mistakes beginners make with sparklines.
Hint: Look back at the tip box on this page.
11. Teach the steps out loud in under one minute.
Hint: Why → What → How.
12. Save the sheet as FreshGoMart_practice.xlsx.
Hint: Use a clear file name for class.
Loading practice tasks...
- Total deals won (Easy): Add up Deals won in the "Deals won" column.
- Average avg (Easy): Average of the Avg deal value (£) column, rounded to 2 decimals.
- Rows in North (Easy): How many rows have Category/group "North"? (the "Region" column)
- Largest deals won (Easy): The largest value in the "Deals won" column.
- Deals won for North (Medium): Total of the Deals won column where Region is "North".
- North in Leeds (Medium): Total of the Deals won column where Region is "North" and City is "Leeds".
- Best in North (Medium): Largest value in the "Avg deal value (£)" column where "Region" is "North".
- Value of row 2 (Medium): Multiply the first-row Deals won by the first-row Avg deal value (£).
- Look up Mateo Garcia (Medium): The Deals won for "Mateo Garcia" (use a lookup on the "Name" column).
- Total value (Hard): Sum of "Deals won" times "Avg deal value (£)" for all rows.
- Share of North (Hard): Share of the "Deals won" column that is "North", rounded to 3 decimals.
- Total "Deals won" for North (Hard): Add up the "Deals won" column for the rows where "Region" is "North".
- Above average? (Hard): "Above" if the "Avg deal value (£)" value in the first row is above the average of the "Avg deal value (£)" column, else "Below".
Quick revision cards
Three standalone cards. Each one explains the idea with its own example. Scan the QR to open this lesson.
