 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
I am creating an Excel sunburst chart.
Example
Inner Segment = Division
Next Segment = Department
Outer Segment = Rating (Good, Average, Poor)
The sunburst automatically colours each division, department and rating under the same colour based on division (which I am happy with)
However I would like to change the outer segment rating to reflect Good (Green), Average (Yellow) and Poor (red)
Can you do this?
Thanks in advance
Not sure it's a standard feature - you can change each segment manually so depends how many there are and how often the ratings change. If you're competent with VBA you could build a macro to remap the colours.
so depends how many there are and how often the ratings change. If you’re competent with VBA you could build a macro to remap the colours.
Too many segments, and would change too often to manually change, something I had already considered.
...and my macro skills are not great other than recording a basic function!
I don't think there's any other way to do it in a chart, the conditional formatting options are only for cells.
I have one set up at work that does this but it required VBA