Pie Chart Incorrect?

[watson150]

Hi Everyone,

As you can see from this image, the 'Qty on hand' is a minus figure, yet the share of 'on hand' and 'to be ordered' are split 50/50 on the chart, when really 100% of the item should be 'To Be Ordered'

Any ideas on how to have this chart show the correct need?

Chart.JPG

[teylyn]

Hello,

another excellent reason not to use pie charts in the first place, especially not with a 3D effect (if you want to know why, read this). They plot all values as absolutes, so negative values will be plotted as positives. Use a horizontal bar chart instead and you'll get a clearer picture.

cheers, teylyn

[watson150]

Hello,

another excellent reason not to use pie charts in the first place, especially not with a 3D effect (if you want to know why, read this). They plot all values as absolutes, so negative values will be plotted as positives. Use a horizontal bar chart instead and you'll get a clearer picture.

cheers, teylyn

Thanks heaps for that!