Official Excel gridlines are one color/style only. There are ways to fake a
gridline:

http://peltiertech.com/Excel/Charts/...Gridlines.html
http://peltiertech.com/Excel/Charts/AddLine.html

What you might want, if the zero is between the min and max, is to keep the
axis (a distinct line) at zero, but change the label position to "Low" so
they're out of the way.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"James Silverton" wrote in message
...
Jon wrote on Wed, 23 Nov 2005 07:54:26 -0500:

JP 0.00;-0.00;-;@

JP The four parts are for positive, negative, zero, and text
JP values. Remove the item in the zero's spot:

JP 0.00;-0.00;;@

JP More on number formats:

JP http://peltiertech.com/Excel/NumberFormats.html

Again, making a comment while not the OP, that is a fascinating discussion
Jon. I was particularly interested to find out for the first time how to
change the color of a particular value.

A rather similar problem has intrigued me for some time: is it possible to
change a gridline for a particular value to a different thickness or
color? I can find a use for this when the zero value for the y-axis is
inside the chart rather than along an edge.

Again, thanks in advance and my apologies if I should have been able to
find this in Help.


James Silverton.