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.

Sunburst charts

Sunburst charts

From the course: Excel: Charts in Depth

Start my 1-month free trial Buy for my team

Sunburst charts

“

- [Instructor] The next worksheet over, Sunburst, has the same data, but we can view the data differently. This is somewhat like a doughnut chart. I'll click over in columns A, B, and C > Insert tab. Let's go to that same icon, Sunburst. There it is, and here, too. Making this a lot larger. Move it to the upper-left corner. We can see what's happening. At a glance, we can make the assertion, looks like a quarter of our people here are in manufacturing. We've got two rings. The inner ring represents the data from column A. Quality Control has a big chunk of people. So does Project and Contract Services. We're not seeing numbers or percentages, but we get some sense of the percentage idea based on the size of these, just as we do in treemap but in a different way, of course. Here, too, with data labels off to the right, we want to add more data labels and put in the value. And there we see it, and that makes a lot of…

Contents