Change 1 gridline

[aks710]

This is probably a very easy question I just haven't spent a lot of
time with Excel charts. How do you change the style of 1 gridline on a
chart?

The data on the Y axis is from -2 to 6 and we would like the line at 0
to be darker than the other gridlines.

Thanks,
Anna

 

[HEK]

Anna, isn't this line just your category axis? Then just select the
gridlines and change their colour, e.g. light grey / dotted, to discriminate
from the cat axis
Regards,
Henk

 

[ju1eshart]

This edits all gridines, I've been trying to use a gridline as a
cut-off/target but I only want to edit the colour of one specific gridline.

 

[Don Guillett]

try
format axis>patterns>lines>custom>weight

 

[ju1eshart]

even if i select one gridline and fomat axis the format is still applied to
all gridlines. jules

 

[ju1eshart]

continued from below,it's a 3D chart, I have several gridlines log scale 0.1
to 1.0E+08 and gridlines evey 10

 

[Don Guillett]

try selecting the AXIS by right click on a number at the bottom>format
axis>>>>

 

[ju1eshart]

can I e-mail to you at austin.rr

try selecting the AXIS by right click on a number at the bottom>format
axis>>>>

 

[Don Guillett]

sure