zero values

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
 
D

David Biddulph

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I don't want to graph "null" values? 1
Surpressing plot of blank cells 3
not draw zero values in a line chart 1
Hiding zero values on a chart in Excel 2007 2
linear charting with zeros 7
Blank cells in graph 8
Excel 2002 Zero Values in Charts 2
Hide Cells with Zero Value in Excel 2007 while using line chart ty 4

Top