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