I am looking for way to color automatic cells in sunburst chart from set data from another cells. Can you help me?
This should get you close:
I did have to step into 'B' change the fill to 'no fill'. Seems like [Revenue] controls the weight of the graph where A:E controls the hierarchy.