Hi,

If you do not want the zero to show you can do one of the following
- delete it and have empty cell instead
- type #N/A
- use formula =NA()

Select chart and use Tools Options Chart and make sure the Plot empty
cells as: is not set to zero.

Have to ask though why, in your case, is zero not a valid number that should
be shown?

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Ralph D''Andrea" wrote in message
...
I'm using a line chart to display my info. I only have to show the points
on
the graph. I found where to hide the line so only the points show. The
only
problem is if I have a value of zero it's displaying a point at ZERO on
the
axis, this is not what I want. I can't find where / how to (remove or
hide)
point if a value of ZERO. Is this possible?

Please advise