I have a chart which has some conditional formatting on it.
less than 0 is green
0-2 is amber
2> is red
The problem is that if the value in the chart is exactly Zero then it doesn't show a colour, and looks like a missing value. I've tried to set the baseline to be -1 or some such, but I see that that is a read only property. Can i manipulate the axis in some other way.
Any ideas (aside from making sure my values are never 0!)