View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
dot dot is offline
external usenet poster
 
Posts: 29
Default Don't Show Zero Data

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?