deleting 0% in a pie chart

[Dona]

I need help. I created a pie chart in a subreport. The chart is linked to a code. Every page is different which is what I want. However, I do not want the pie chart to show a 0% when the no response field (or any other field) is zero. After all who wants a pie chart with a 0% as one of the slices. I've looked through help and my books but I can't find any references. Don't I need a code? If so, where do I type it in?
I'm using Access 97.

Please help!
Thank you for your time.

 

[Rich]

Not Is Null or <>0 in the criteria section of the report's underlying query field

 

[Dona]

Pie Chart exclude 0%

Hi Rich,
If I put Not Is Null or <>0 in the criteria section of the report's underlying query field, would it not exclude the entire record. I just want to exclude one field out of a record. The pie would have 30% carrots, 40% lettuce and 30% tomatoes. The 0% of potatoes would be excluded from the pie chart. However, the next record might have 25% potatoes, 35% carrots, and 45% lettuce, and 0% tomatoes.

Is there a code that I could use? If so, where do I put it.

Please help. Thank you.