not draw zero values in a line chart

  • Thread starter Thread starter ana
  • Start date Start date
A

ana

Hi
I’m trying to create a line chart but I don´t want the zero values or empty
cells to be draw. the line should be inetrpolated from de last value to the
next .
 
Two parts
To skip blank cells, go to Tools-Options->Chart. Select Plot empty cells as
not plotted. (Note cell must be empty, not a formula returning "")

Zero values are a little trickier. You'll need to either remove them (Find
and Replace) or if they are a formula, have the formula return the #N/A error.
Example:
=IF(A1=0,NA(),A1)
XL charts ignore the #N/A error as they are, by definition, 'not applicable'.
 
Back
Top