View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Mac Mac is offline
external usenet poster
 
Posts: 213
Default Bar chart with no zero columns

I have a colums with a hundreds a values and only twenty is real values the
rest is all zero. How do I plot a bar chart showing only the values and omits
the zero values from the chart. My chart is plotting all zero values which
makes it impossible to view. Is there a way of not plotting the zero columns
without filtering the data. I read the previous posts but the NA() allso
shows zero values. Any help would be appreciated. Thanks