From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 23,200 courses taught by industry experts.

Exploring treemap charts to display hierarchical data

Exploring treemap charts to display hierarchical data - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Exploring treemap charts to display hierarchical data

“

- [Instructor] There's no question 2 that the two charts we're seeing on the screen here 3 can be attention getters. 4 They're what we call treemap charts. 5 Excel has two chart types referred to as hierarchy charts, 6 and they're somewhat limited in the data that they can show, 7 but it shows data very clearly. 8 On the insert tab, in the ribbon, 9 among the many chart icons, 10 is the one I'm pointing to right now. 11 Hierarchy chart, notice the two types 12 and we'll notice the distinction between the two. 13 Treemap, its description includes the phrase, 14 the data is organized hierarchically 15 and has fewer categories, whereas sunburst, 16 the data is organized hierarchically 17 and has many categories, 18 and you might have seen a previous weekly tip on sunburst. 19 The chart on the left here is depicting the data 20 in columns A, B, and C. 21 It's only 32 rows of information, 22 but we can see pretty…

Contents