Need Sunburst Point to fill green if cell is green

[Ochimus]

Cols C - E on attached list sites where various activities have taken place. This is displayed in the adjacent Sunburst chart.

Where audits have been carried out, the cells are filled in Green (e.g. C4, D5 AND E8)

Where cells are green, I want the Sunburst Point to fill in green as well (as shown (badly) in the image below the Sunburst)

Hovering over a Point, the tooltip shows Point "[cell name]", but I cannot work out how to quote that in the Code?

Please Login or Register  to view this content.

Marc provided a solution that worked on Donut charts, but doesn't seem to translate to a Sunburst?

Any solutions, suggestions or alternatives welcome as ever.

Ochimus

[carlmon]

Try recording a macro to get the relevant properties of the sunburst chart.

[Ochimus]

Carlmon,

Appreciate the suggestion, but first Code creating a 'new' Sunburst just sets it as a Sunburst in Style "381".

Please Login or Register  to view this content.

Then tried selecting the specific Point and changing the colour manually:

Please Login or Register  to view this content.

It worked initially, but two problems.

1. When I reset the colours of the two sectors and tried to run it again, it generated the error Message attached when applying the Data Labels to Points(14).
2. Can't see how Points number links to the cell reference in any way (e.g. Point 14 and Point 15 of what? There are seventy two possible cells, only fifty six have content, and can't see any combination that makes Pack 4 and Pack 5 the 14th to 18th of anything?

Ochimus