MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Don't want to plot zero values in line chart

Posted by marbel on November 10, 2000 3:42 PM

I have dates on an x axis, and two series of data (last year and this year.) Since this year isn't done yet, I want to plot only real values, not zeros (it makes the line crash into the x axis.) Problem is, the data series is a series of formulas calling values from another worksheet, so even an IF statement clause of "" won't work. Excel still plots that value as zero instead of treating it like a blank. Hmm!

Posted by AB on November 13, 2000 7:49 AM

Try using the IF clause with NA() instead of ""

Posted by marbel on November 13, 2000 9:34 AM

YEAH! Very effective!