Can't change gridlines colour a second time

[AlisonB]

Hi,

I changed my chart gridlines to white to make them invisible and I now
want to change them back but I can't find them! When I scroll over the
chart I can only click on the plot area, not the white grid lines.

Can someone tell me how to change the colour again?

Kind regards,

Alison

 

[David Biddulph]

Hi,

I changed my chart gridlines to white to make them invisible and I now
want to change them back but I can't find them! When I scroll over the
chart I can only click on the plot area, not the white grid lines.

Can someone tell me how to change the colour again?

Have you tried clicking on the right hand or top edge of the chart? If your
axis & gridline spacings are still on the auto settings, you'll normally
find a grid line at the edge.

Another way, if you can't find the white lines on the white plot area, is to
change the plot area colour to something other than white.

 

[AlisonB]

Doh! Can't believe I didn't think of that! Thanks for your help.

Kind regards,

Alison

 

[Jon Peltier]

Another way is to select them in the chart element drop down on the chart
toolbar.

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

 

[Andy Pope]

Yet another way is to use the cursor keys to cycle through chart elements.
http://www.andypope.info/tips/tip003.htm

Cheers
Andy