0 Replies Latest reply on Nov 16, 2010 7:33 AM by TheGarfunkal

    changing the baseline on a bar chart




      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!)