not draw zero values in a line chart
 

Hi
Im 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 .

not draw zero values in a line chart
 

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'.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"ana" wrote:

Hi
Im 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 .