Color Expressions not working in QV9?

[#1]

Hi all,

I'm trying to set a color expression for a scatter chart. Basically, I would like all those balls that indicate a value > 400 to be a different color.

I've changed all the colors to a calculated value, but it's not taking. Does anybody have any suggestions what I'm doing wrong?

Thanks!

Oliver

[#2]

I have a stacked bar chart. This shows proportions against three values, 'Yes', 'No' or 'N/A' (field "Satisfaction"). These are also represented by -1, 0 and 1 (field "Satisfied").

To make sure, especially when drilling down, that colours are Green, Red and Yellow respectively, I am trying to use the Color Area Base Color Calculated feature from the Colors tab. Neither of my formulae work:

=if(Satisfied=-1,rgb(0,255,0),if(Satisfied=0,rgb(255,0,0),rgb(255,255,0)))
=if(Satisfaction='Yes',rgb(0,255,0),if(Satisfaction='No',rgb(255,0,0),rgb(255,255,0)))

When I apply either of these formulae to the background colour of the cells of a straight table object, they both work just fine.

Is this a bug in Version 9, or just my formulae?

[#3]

It would appear that whatever variables I am using for my colour formulae, they are null. Is there a way to perpetuate a value in a chart without it appearing in the chart? Seems to make the calculated colour pretty redundant if not.