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

    changing the baseline on a bar chart

    TheGarfunkal

      Hiya

       

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

       

       

       

      Andrew