From the course: Excel: Charts in Depth

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

TreeMap charts

TreeMap charts

From the course: Excel: Charts in Depth

Start my 1-month free trial

TreeMap charts

“

- [Instructor] Two of the newer charts introduced in Excel 2016 are called Treemap and Sunburst, and in our chapter seven exercise file, our first two sheets are called Treemap and Sunburst. They're similar in nature, and yet you'll want to explore both of them if you're working with hierarchical-type data. I think you'll find, too, that if you're working with lots of data, say 50 rows or more, it might not work so well. But we got some information over in columns A, B, and C. It's been restructured and created again over in columns E, F, and G, and sorted differently. Let's just click over in the data to the left. It is surrounded by empty cells, so we can quickly create a chart simply by pressing Alt-F1. And that's a clustered column chart, and the more you look at it the more you'd say, that's just not very useful. Let's get rid of that. So, going back to the Insert tab, Chart Group, right here, we see Insert…

Contents