zero values
 

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

zero values
 

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.
--
David Biddulph

"Michel" wrote in message
...
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