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

Excel 2007 charts: want to avoid zero values 1
I don't want to graph "null" values? 1
Surpressing plot of blank cells 4
Scatter chart with categories on x-Axis 2
not draw zero values in a line chart 1
Hiding zero values on a chart in Excel 2007 2
Zero length string on chart 1
Earned value (BCWP) showing as zero in chart 0

Top