Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can't change gridlines colour a second time
"AlisonB" wrote in message
ups.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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can't change gridlines colour a second time
Doh! Can't believe I didn't think of that! Thanks for your help.
Kind regards, Alison |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can't change gridlines colour a second time
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" wrote in message oups.com... Doh! Can't believe I didn't think of that! Thanks for your help. Kind regards, Alison |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can't change gridlines colour a second time
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can a formula change a cells colour after a given length of time? | Excel Worksheet Functions | |||
change date based on time | Excel Discussion (Misc queries) | |||
How do I change . to : when input in a time sheet by error | New Users to Excel | |||
Time Stamp without change | Excel Discussion (Misc queries) | |||
Time Stamp-With Change | Excel Discussion (Misc queries) |