You could also use an Autofilter, and hide any rows with zero in that
column. By default, hidden cells are not included in charts.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"Accounts" wrote in message
...
Would anybody know how I can avoid showing data point gaps on a column
chart.
E.g.
Red Wine 1000
White Wine 0
Rose Wine 1400
How can I avoid showing White Wine in the chart (without deleting the
row)?
Any comments would be greatly appreciated
Thanks
Accounts