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
For a treemap, many students give a summary table (city in one row, areas beside it) – and the chart isn't created. Hierarchy charts need long format: every row has City, Area, Sales. And if there are more than 30 small boxes, the labels don't show – take the top items.
Ravindra Bagale's Tip – मराठी
Treemap साठी बरेच students summary table (एकाच row मध्ये city, बाजूला areas) देतात – chart बनतच नाही. Hierarchy charts ला long format लागतो: प्रत्येक row ला City, Area, Sales. आणि 30 पेक्षा जास्त लहान boxes असतील तर labels दिसत नाहीत – Top items घ्या.
Ravindra Bagale's Tip – हिंदी
Treemap के लिए बहुत से students summary table (एक row में city, बगल में areas) दे देते हैं – chart बनता ही नहीं. Hierarchy charts को long format चाहिए: हर row में City, Area, Sales. और 30 से ज़्यादा छोटे boxes हों तो labels नहीं दिखते – Top items लो.
Practice task
Create a treemap of sales by Category › Product and a sunburst of orders by City › Area.