Dynamic Pie Chart Slice Colours via VBA

[mikeymay]

Is there a way of creating an array that will hold lists of RGB values based on a static list of possible slices in a pie chart in order to colour those slices based on the list?

E.g.

The full list of possible options and their colours - the cells would be coloured as per the list below
Option 1 - Red
Option 2 - Green
option 3 - Blue
Option 4 - Grey
Option 5 - Yellow

If a pie chart consists of
Option 1
Option 3
Option 5

How do I utilise an array to hold the full list of options and RBG values to then loop through each point in the pie chart and colour those slices?


TIA

 

[Derek Brown]

I wonder if the following process will give you a solution:
Color Pie Chart Slices to Match their Source Cells – Bacon Bits

 

[mikeymay]

Thanks Derek, that looks exactly what I need!

I am looking at this part of the project next week so I'll pick it up then.


Thanks