Gauge chart conditional formatting on color

[cognos05]

Hi,

I wanted to show sales to budget achievement % in a gauge chart.

I have a  query item which calculates and provides the percentage. I am using this data item in the simple gauge chart with label outside chart control .

I dont see an option to change the color when the percentage growth is negative or define color based on percentage range .

Is there a way to achieve this . There is only a render variable property and no conditional formatting.