Chart - empty cells show as 0?

  • Thread starter Christine Wilso
  • Start date
C

Christine Wilso

I dont want empty cells from my data source to show as zero on a lin
chart.
The source data isn't exactly empty as it contains a formula
=IF(C7>0,C7,"")
And I think it is because of the formula my line sweeps down to zeer
for all the months that contain no figures.
How can I get round this
 
Top