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 करो.
Practice task
Add line sparklines with high/low points for six cities and column sparklines for daily orders of the last 14 days.