Treemap and sunburst in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a treemap chart in Excel?

A treemap chart shows hierarchical data as nested rectangles. Each rectangle's size represents a value, making it easy to compare parts of a whole.

beginner

What is a sunburst chart in Excel?

A sunburst chart displays hierarchical data as concentric rings. The center is the top level, and each ring outward shows deeper levels.

beginner

How do you create a treemap chart in Excel?

Select your hierarchical data, go to Insert > Charts group > Insert Hierarchy Chart > Treemap.

beginner

How do you create a sunburst chart in Excel?

Select your hierarchical data, then go to Insert > Charts group > Insert Hierarchy Chart > Sunburst.

beginner

What kind of data works best for treemap and sunburst charts?

Hierarchical data with categories and subcategories, where you want to show parts of a whole and their relationships.

Which chart type uses nested rectangles to show data?

A Treemap

B Sunburst

C Pie chart

D Line chart

Treemap charts use nested rectangles to represent hierarchical data.

In a sunburst chart, what does the center ring represent?

A The top level of data

B The total sum

C The average value

D The lowest level of data

The center ring in a sunburst chart shows the top level of the hierarchy.

Where do you find the option to insert a treemap chart in Excel?

A Formulas > Insert Function > Treemap

B Insert > Charts > Insert Hierarchy Chart > Treemap

C Data > Sort > Treemap

D View > Zoom > Treemap

Treemap charts are inserted via Insert > Charts > Insert Hierarchy Chart > Treemap.

Which chart is best to show hierarchical data as rings?

A Bar chart

B Treemap

C Sunburst

D Scatter plot

Sunburst charts display hierarchical data as concentric rings.

What type of data is NOT suitable for treemap or sunburst charts?

A Hierarchical data

B Data showing parts of a whole

C Data with subcategories

D Flat list without categories

Flat lists without categories do not show hierarchy, so treemap and sunburst charts are not suitable.

Explain how to create and use a treemap chart in Excel.

Think about the steps from selecting data to seeing rectangles sized by values.

Describe the difference between treemap and sunburst charts and when to use each.

Focus on the visual style and how hierarchy is displayed.