Coloring Radial Pie Chart Slices Based on a Column's Format

I have a radial pie chart created using this tutorial: https://superuser.com/questions/6870...ie-radar-chart

I would like to color each of the sectors based on the colors in a column that is not used in the chart yet. For example, in the above example, it would be as if I had a separate column that is in the worksheet, and the values in that column are conditionally formatted.

I found this thread (https://stackoverflow.com/questions/...0921818c683394) that is close, but it doesn't work for my particular type of chart, as each segment is a different SERIES.

Is there anyway to do this??

Thanks!

This will give you a start.

I coloured a cell (A2) yellow. Then I made this code.

Then I selected a cell other than A2, and ran this code.

Sub colourme()
With Selection.Interior
.Pattern = Range("A2").Interior.Pattern
.PatternColorIndex = xlAutomatic
.Color = Range("A2").Interior.Color
.TintAndShade = Range("A2").Interior.TintAndShade
.PatternTintAndShade = Range("A2").Interior.PatternTintAndShade
End With
End Sub

Now you probably only need the color property for a graph, but this should give you the basic idea.