Change 1 gridline

  • Thread starter Thread starter aks710
  • Start date Start date
A

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
 
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
 
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.
 
even if i select one gridline and fomat axis the format is still applied to
all gridlines. jules
 
continued from below,it's a 3D chart, I have several gridlines log scale 0.1
to 1.0E+08 and gridlines evey 10
 
Back
Top