Change 1 gridline

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
 
G

Guest

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
 
G

Guest

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.
 
G

Guest

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

Guest

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

Don Guillett

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom gridline - one single gridline at a specific value 4
2007 line chart, can't make some gridlines heavier than others 10
Can you alternate background colors by gridline? 1
Move gridlines in a chart so that they are above the numbers 1
Plotting Point on Gridline 1
Log scale and minor gridline labels 2
Adjusting gridlines on the x-axis 1
How can I highlight only one Y axis gridlines in an excel graph?. 3

Top