View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
jhall@ifox jhall@ifox is offline
external usenet poster
 
Posts: 1
Default skip cells with zero values in chart (cells not empty)

I don't want to display zeros in my line chart. The cells are not empty -
they contain a formula. I have used a simple if statement to hide a zero
value - however the chart is still showing the datapoint as zero.