8.9 Treemap and Sunburst
Excel 2016+. Both show hierarchies (Category › Product, City › Area) with size = value.
- Treemap – rectangles; best to compare sizes within a hierarchy.
- Sunburst – rings; best to show levels of a hierarchy.
Steps in Excel
- Arrange data with hierarchy columns first: City | Area | Sales (City repeated on each row).
- Select it › Insert › Charts › Insert Hierarchy Chart › Treemap (or Sunburst).
- Ctrl + 1 › Series Options › Label Options › Banner for parent labels (treemap).
Worked example. Treemap of sales by City › Area: Pune's block (Kothrud, Hinjewadi, Baner, Hadapsar, Wakad) is the largest; inside Nagpur, Dharampeth is bigger than Sitabuldi.
Ravindra Bagale's Tip
Treemap sathi khup students summary table (ekach row madhe city, baju la areas) detat – chart banatach nahi. Hierarchy charts la long format lagto: pratyek row la City, Area, Sales. Aani 30 peksha jast lahan boxes asle tar labels disat nahit – Top items ghya.
Practice task
Create a treemap of sales by Category › Product and a sunburst of orders by City › Area.