View Single Post
  #1   Report Post  
cybermrt
 
Posts: n/a
Default How can I make a none value cell not show as zero on a chart?

If a cell has a hidden fomula that returns a blank cell, then the chart
always reads this as a zero and plots the line as a zero?

Similarly if the cell contains a letter rather than a number, this will also
be plotted as a zero?