Setting colors for Chart - Legacy charts

[RoryF]

Hello All..

Is there any way to set the colors for the pie chart below (which is a legacy chart - not a new chart).  The legend is pain level and it would be best if the range from 1-10 went from Green to Red as these are generally accepted colors for this scale.

Importantly this is the "2nd level" of chart columns..

Any thoughts?

Thanks,

RoryF

[graham_howe]

Just add the 10 colours with their appropriate hex values. I found a range with 5 here, but you can get the idea

[RoryF]

Thanks Graham..

It doesn't work quite the way I wanted but it is better than what I had. I now know how it works; but it also colours the "parent" chart with the same colours so now my parent chart (which has 3 segments) are various shades of green..

I guess that's as good as it's going to get..

Thanks,

RoryF