Exclude 0 from Pie Chart

[Dona]

I need help. I created a pie chart in a subreport. The chart is linked to a code. I want to exclude one field out of a record. Each store may have a different inventory. The pie chart may have 45 potatoes, 20 tomatoes, 30 lettuce and 0 green beans. I want to exclude the green beans from the chart. Another record may have 0 tomatoes, 25 potatoes, 54 lettuce, and 34 green beans. I want to exclude the tomatoes from the chart. After all, who wants a pie chart with 0% as one of the slices. I've looked through help but I can't find any references. Don't I need a code? If so, where do I type it? I'm using ACCESS 97. See attachment.

Please help! Thank you for your time.

 

[RichMorrison]

I think your table structure is a problem. You need to normalize the table so each record has:
Store,
Type of Produce,
Number of Items

Then create a query that only selects records where Number of Items > zero.

Use the query in your graph.

That should do it.

RichM