View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
groj
 
Posts: n/a
Default Plotting "blank" cells as zero

How can I keep an excel chart from plotting a blank cell as zero?

I am plotting a series of numbers, each month. If the month is not here yet,
then that cell is calculated as a blank. But the chart still plots it as
though it was zero.

Any ideas?

Thanks