Thread: Can't change gridlines colour a second time

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

"AlisonB" <alison.broadley@ntlworld.com> wrote in message
news:1147361275.614198.57790@y43g2000cwc.googlegroups.com...
> 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.
--
David Biddulph

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

Kind regards,

Alison

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/
_______

"AlisonB" <alison.broadley@ntlworld.com> wrote in message
news:1147362503.254528.144950@i40g2000cwc.googlegroups.com...
> Doh! Can't believe I didn't think of that! Thanks for your help.
>
> Kind regards,
>
> Alison
>

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

Cheers
Andy

AlisonB wrote:
> Doh! Can't believe I didn't think of that! Thanks for your help.
>
> Kind regards,
>
> Alison
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info