OWC11 Conditional 3D Bar Chart Coloring Question

[Jonathan Stone]

Hi,

Wondering if anyone has been successful with this. I am trying to color a 3D
Bar Chart's bars conditionally upon value. The values are percentages (This
is an availability management chart for application uptime, if that helps).
I want the colors to vary from red 0%-65%, then yellow from 65%-93%, then
green from 93%-100%... of course varying in color range of red, yellow and
green such that a 93.2% would indicate the more yellowish green. It may even
be fine that the conditional variance is between only red and green, but I
need to find a creative way that the red value doesn't always attach to the
lowest value i have and then conditionally move towards green in the scale
of values in the chart.

So I am basically getting red on my lowest 89.1% value, which I would want
to be a yellowish color...

I've been messing around with it for a few hours now, but I will reserve
from getting to into it if someone else knows how to do this.

Thanks.

 

[Thao Moua [ms]]

If you're using the property toolbox to accomplish this, you will not get the desire affect. Try creating your conditional formatting through code as it will give you more control on where your red, yellow, and green segments will start and end

--------------------------------------
Thao Mou
OWC Chartspace Suppor

This posting is provided "AS IS" with no warranties, and
confers no rights. Use of included script samples are
subject to the terms specified at
http://www.microsoft.com/info/cpyright.ht

----- Jonathan Stone wrote: ----

Hi

Wondering if anyone has been successful with this. I am trying to color a 3
Bar Chart's bars conditionally upon value. The values are percentages (Thi
is an availability management chart for application uptime, if that helps)
I want the colors to vary from red 0%-65%, then yellow from 65%-93%, the
green from 93%-100%... of course varying in color range of red, yellow an
green such that a 93.2% would indicate the more yellowish green. It may eve
be fine that the conditional variance is between only red and green, but
need to find a creative way that the red value doesn't always attach to th
lowest value i have and then conditionally move towards green in the scal
of values in the chart

So I am basically getting red on my lowest 89.1% value, which I would wan
to be a yellowish color..

I've been messing around with it for a few hours now, but I will reserv
from getting to into it if someone else knows how to do this

Thanks