Don't Show Zero Data

[dot]

Hi All

Is there a way to not show data on a bar chart if the data is =to Zero. (e.g.)
Name: Amount:

Almond Cream Cake 0
Apple Strudel 3
Asian Spice 0
Baby Powder 5
Bed of Roses 0
Berry Mulbery 0
Bird of Paradise 6
Butterfly Kisses 4
Buttery French Vanilla 0

I have about 65 rows of data I just didn't put it all here. When I use the
chart wizard it shows all the names even if the amount is 0.(Cluttered) I
just want to chart names that have numbers next to them that are greater than
2. The numbers change weekly. Can this be done?

 

[Andy]

Hi dot

Good timing....I found this only yesterday.

http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=535

cheers...Andrew