Change Barchart colour from value

[Brianfree]

Hi, i am trying to figure out how to change the colour of a bar chart at a certain percentage value

101%+ Is Blue
86% to 100% is Green
51% to 85% Is Amber
0% to 50% Ref


So on the barchart if i have a value of say 75% i want the bottom of the chart upto 50% to be red, the value from 51% to 75% to be amber.

Is this possible, if so pleae can anyone provide an example..

thankyou in advance.

Brian

 

[SkipVought]

Hi,

Use a Stacked Bar. This will mean that your chart data will also need to be stacked. Your single value will need to be divided into 4 values from 4 formulas, based on the criteria you posted. Give that a try.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]