Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charts graying out
Hi,
I have a series of charts updating from a simple table with various formulas. All has worked well for a couple of months when this morning all of the charts were grayed out. They are now covered by a shaded gray area, I can select the chart with my mouse and the chart will display normally, move the mouse to a new cell and chart is covered over again. I'd appreciate any ideas as to why this is happenning, I have moved the file to a different machine but have the same problem. Thanks, Mickey |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charts graying out
Hi,
To return your charts to normal display use Tools Options View Objects - Show All. I do not know why it would have been set to Show Placeholders. Cheers Andy Mickey wrote: Hi, I have a series of charts updating from a simple table with various formulas. All has worked well for a couple of months when this morning all of the charts were grayed out. They are now covered by a shaded gray area, I can select the chart with my mouse and the chart will display normally, move the mouse to a new cell and chart is covered over again. I'd appreciate any ideas as to why this is happenning, I have moved the file to a different machine but have the same problem. Thanks, Mickey -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Charts graying out
That's fantastic!
Thanks very much Andy. I've no idea how the setting changed but amazingly whilst I was recreating the file just now, the same thing happenned to the charts. I wonder if it is something to do with a key combination as I type on my laptop. Thanks again, this will save me a ton of time. Regrads, Mickey "Andy Pope" wrote in message ... Hi, To return your charts to normal display use Tools Options View Objects - Show All. I do not know why it would have been set to Show Placeholders. Cheers Andy Mickey wrote: Hi, I have a series of charts updating from a simple table with various formulas. All has worked well for a couple of months when this morning all of the charts were grayed out. They are now covered by a shaded gray area, I can select the chart with my mouse and the chart will display normally, move the mouse to a new cell and chart is covered over again. I'd appreciate any ideas as to why this is happenning, I have moved the file to a different machine but have the same problem. Thanks, Mickey -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting rid of unusable charts? | Excel Discussion (Misc queries) | |||
Getting rid of unusable charts? | Charts and Charting in Excel | |||
Pasting worksheet with embedded charts | Charts and Charting in Excel | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel | |||
linkingof charts in worksheets to cells | Excel Discussion (Misc queries) |