View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Accounts Accounts is offline
external usenet poster
 
Posts: 2
Default Zero values in charts

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