From the course: Excel: Charts in Depth

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

TreeMap charts

TreeMap charts

From the course: Excel: Charts in Depth

Start my 1-month free trial Buy for my team

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