2 Replies Latest reply: Jun 17, 2011 6:16 AM by lavvyvkt RSS

    Pie chart Issue

      Hi All,

            When I try to show the negative values in Pie chart it shows me an error

      "Positive and Negative values in chart".. Is there any way of shwing the negative values in the pie chart...

       

      Plz let me know if you have any answer for this...

       

      Thanks,

      Lavanya

        • Pie chart Issue
          Jonathan Dienst

          Lavanya

           

          A pie chart can show all negative values, but only if all the values are negative. It cannot display a mix of positive and negative. A pie chart pretty meaningless when you have a mix of positive and negative values.

           

          If you must use a pie chart, you can modify your expressions like this:

           

          =RangeMax(your_expression, 0) to clip out negatives and display only positives

          =RangeMin(your_expression, 0) to clip out positives and display only negatives

           

          Hope that helps

          Jonathan