Sunburst Chart - Subcategories

[tobyhill96]

I've been tasked with a work project that involves creating a diagram outlining all of our workplace's features and benefits in one place. The idea is that the features are in the middle with the benefits moving to the outside.

I have used a sunburst chart to visually demonstrate the early drafts of this model, however I am unable to find a way to add sub features. 

Below is a simple demonstration of what I would like using every day meals. The types of food are in the middle, with the benefits on the outside. 

This is all well and good, but consider there are two very different types of Pizza - a high quality restaurant pizza, and a store bought frozen pizza. Both come under pizza, however have different benefits. 

Is there a way, I can add the different categories of pizza into the same wedge? I still want pizza as the overall category, and it is essential that all the benefits remain in the same layer. 

This is the current table.

And below is what I hoped would work - and if the above information wasn't clear, what I want the end product to look like. 

I know this is not what the graph was intended for however I'm not a graphic designer and the chart is so effective at showing a large amount of information! In my work example, There are currently 100s of rows and 6/7 columns. It needs to be condensed to about 4

https://1drv.ms/x/c/5359ede10ede60da/EfmRzCeMzgFOvzJq-ySGVicBYKVZj3imFSbCLazv7gASrQ

Thanks in advance for your help!

[#2]

Not sure what the issue is; you can create a sunburst from your second table?

[#3]

@tobyhill96 

If this was most any other chart type, I'd put the subcategories on the data labels (value from cells) but Sunburst has limitations.

Here's my workaround. It may not be exactly what you wanted, but it's an option:

[#4]

You can but it doesn't solve the problem as it doesn't register them as subcategories.

[#5]

Thanks for this - I understand the reasoning completely. Unfortunately, I don't think this would be clear on the project I'm working on as it's not immediately obvious with the amount of text on there.

I thought it may be the case that it's just not meant for sunburst, however, i'm not sure of an alternative that doesn't eat up loads of time/can be easily adjusted.

[#6]

Try creating the sunburst chart anew, based on your new data layout. Make sure there is something in each cell of the subcat column, if needed just a space.