Regarding Pie Chart zero values

[#1]

Hello There,

I have this situation and my dataset looks something like this.

Bucket     Amount_Due

Current          1000

31-60 Days     2000

61-90 Days     1500

91-120 Days     0

121-150 Days     0

151-180 Days     1200

181 Days and Over     5000

So I am trying to build a pie chart, but because the bucket with 91-120 Days and 121-150 Days doesn't have any values so the legend doesn't show these values. So in the legend it looks something like this...

Can you please suggest how can I put all the values of the field in the legend and in the pie chart may be i can show them as zero %.

Thanks.

[#2 · Accepted solution]

Right click pie chart > Properties > Presentation > uncheck suppress zero and suppress missing boxes

Should do the trick.

Thanks

AJ

[#3]

I take it back. This usually works for tables, bar charts,etc.. but when I tried for Pie it didn't, but then it occurred to me that in a pie you can't show zero values. The circle is split into different pies based on the positive non-zero values only.

Thats the whole concept for using Pie.

[#4]

Btw i tried...and it is working fine...thanks for the answer...

yours might be something other issue...

[#5]

Really? Thats quite interesting. Now you have got me thinking. Can you post a snapshot(pic) of the pie. Just curious to see how it looks if you dont mind.

[#6]

It looks like this now....

[#7]

Glad its working for you.

I tried in QV 10 SR 6 and it didn't.