Help with Sunburst Chart

[Paulspencer8884]

Hi,

I wondered if someone could help me.

I am trying to show the movement of customers from one product to others within a Sunburst Chart and show the respective values.

The data I wish to include is as follows:

The product the customer had being the inner ring and the product the customer moved to being the outer ring.
Any help would be much appreciated.



Product Customer Had Total Revenue £000's Product Customer Moved To Total Revenues £000's
Product x 60 Product Y 10
Product X 20
Product D 30
Product Y 80 Product Y 20
Product D 30

Thanks Paul

<colgroup><col width="144" style="width:108pt;" span="2"><col width="183" style="width:137pt;"><col width="136" style="width:102pt;"></colgroup><tbody>
</tbody>

 

[Fluff]

Continuation https://www.mrexcel.com/forum/excel-questions/1046480-sunburst-chart-post5024635.html#post5024635

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).