To make a chart skip a point, and not count it as zero, have it reutrn the
#N/A value. In formual form, this would be:
=If(A2=0,NA(),A2)
--
Best Regards,

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


"spudsnruf" wrote:

Hello, I have a simple line chart, generated from a list of numbers, many of
the numbers are zero, which I dont wnat to show up on the chart. At the
moment, they show up as a point on the bottom of the horizontal axis. How do
I make sure they dont show if zero please? Thank you.