zero values

  • Thread starter Thread starter Michel
  • Start date Start date
M

Michel

Hello,
I would like to know how to prevent cells with values zero or empties
(is it the same ?) to NOT be plotted in the chart ?
After the last dot on the chart matching the last value on the
spreadsheet, the line descend to zero on the graph
Thank you

Michel
 
If you have a formula that is returning either 0 or "" and you want those
results not to be plotted as zeroes, get the formula to return NA() instead.
 
Back
Top