8. Charts
Chala mitrano, aaj aapan aakde "bolke" karuya – charts. Kontya prashnasathi konta chart, to kasa format karaycha, aani dynamic charts (drop-down, checkbox ne badalnare) kase banvayche – he sagla aaj. Lakshat theva: chart sundar disnyasathi nahi, sandesh spasht karnyasathi asto.
What you will learn in this module
- Creating charts and using Chart Elements, Styles, Filters and the Format pane
- Column, bar, line, area, pie/doughnut, combo with secondary axis, scatter
- Histogram, box & whisker, waterfall, funnel, treemap, sunburst, map chart and sparklines
- A choose-the-right-chart table
- Dynamic charts: Table-based, drop-down + INDEX/XLOOKUP driven, OFFSET named ranges, checkbox show/hide
Chart data used in this module (fictional monthly sales, ₹ lakh, sheet ChartData):
| Month | Pune | Nashik | Nagpur | Orders (Pune) |
|---|---|---|---|---|
| Jul | 3.9 | 1.4 | 1.6 | 12,150 |
| Aug | 4.1 | 1.5 | 1.7 | 12,900 |
| Sep | 5.9 | 2.0 | 2.1 | 17,600 |
| Oct | 5.0 | 1.6 | 1.8 | 15,200 |
| Nov | 6.1 | 2.2 | 2.5 | 18,400 |
| Dec | 4.6 | 1.7 | 1.9 | 14,100 |
September (Ganeshotsav) and November (Diwali) are the festival peaks.
Concepts in this chapter
- 8.1Creating and Formatting a Chart
- 8.2Column and Bar Charts
- 8.3Line and Area Charts
- 8.4Pie and Doughnut Charts
- 8.5Combo Chart with a Secondary Axis
- 8.6Scatter Chart
- 8.7Histogram and Box & Whisker
- 8.8Waterfall and Funnel
- 8.9Treemap and Sunburst
- 8.10Map Chart
- 8.11Sparklines
- 8.12Choosing the Right Chart
- 8.13Dynamic Chart from a Table
- 8.14Drop-down Driven Dynamic Chart (INDEX / XLOOKUP)
- 8.15Named Ranges with OFFSET (Rolling Charts)
- 8.16Checkbox to Show/Hide a Series
The chapter recap is at the end of the last concept page.