PC Review


Reply
Thread Tools Rate Thread

Can't change gridlines colour a second time

 
 
AlisonB
Guest
Posts: n/a
 
      11th May 2006
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

 
Reply With Quote
 
 
 
 
David Biddulph
Guest
Posts: n/a
 
      11th May 2006
"AlisonB" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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


 
Reply With Quote
 
AlisonB
Guest
Posts: n/a
 
      11th May 2006
Doh! Can't believe I didn't think of that! Thanks for your help.

Kind regards,

Alison

 
Reply With Quote
 
Jon Peltier
Guest
Posts: n/a
 
      12th May 2006
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Doh! Can't believe I didn't think of that! Thanks for your help.
>
> Kind regards,
>
> Alison
>



 
Reply With Quote
 
Andy Pope
Guest
Posts: n/a
 
      12th May 2006
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
in in powerpoint to change text colour in all slide at a time Anil kumar Microsoft Powerpoint 1 25th Sep 2010 06:34 AM
Calculate Time Difference and Change Font Colour =?Utf-8?B?QW5keU9fVUs=?= Microsoft Excel Worksheet Functions 4 1st Feb 2007 04:34 PM
Can a formula change a cells colour after a given length of time? =?Utf-8?B?Q2xpdmUgSHVtcGhyaWVz?= Microsoft Excel Worksheet Functions 1 20th Feb 2006 10:23 PM
Change colour once a certain time period passed Dianne Microsoft Excel Misc 1 10th Jan 2006 06:34 AM
making a cell change colour after a specified period of elapsed time Mighty Magpie Microsoft Excel Misc 3 15th Sep 2004 08:45 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:41 AM.