From the course: Excel: Charts in Depth

Unlock the full course today

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

Sunburst charts

Sunburst charts

From the course: Excel: Charts in Depth

Start my 1-month free trial

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