Hi
I have tried to programmatically control the color of the labels on the dimensional axis on a RADAR chart. I want to split the range into a RED, YELLOW and GREEN bands. e.g. 0 to 5 RED, 6 to 10 YELLOW and 11 to 15 GREEN.
Using the axis-tab, with he FONT option I have managed to change the labels of the axis to one colour. When I use the calculated option, I can't get the labels to have different colours that correspond to the required bands.
When I transform the RADAR to a Pivot-table, I can setup the background colors for the dimension column to match the required bands. But RADARs don't work.
Many Thanks
Jim