I have an Excel document that looks somewhat like this:
|Type||Amount||Days without||Days with little||Days with lots|
|A little intolerable||9||195||234||159|
I'd like to put Type and Amount into a pie chart. Furthermore I want to split each pie section into its other 3 columns, Days without, Days with little and Days with lots.
Sunburst seemed like a good choice to me. However for it to work I need to restructure it into some hierarchical table.
|Days with little||1355||271|
|Less tolerable||Days with||1180||295||4|
|Days with little||648||162|
|A little intolerable||Days with||1755||195||9|
|Days with little||2106||234|
|Days with little||1729||133|
This gives me the result I'd expect:
I have a large dataset however and converting it all into some hierarchical data seems way too inefficient to me. Is there an easier method to get this done?