Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
chart is grayed out
I have one spreadsheet where, whenever I am working in cells, the chart turns
into a big gray square. If I click anywhere in the chart, it reappears, but then goes back to gray as soon as I click a cell. I have never seen this before. Any ideas about how/why and what I can do to fix it? It's pretty complex and I would rather not redo it from the source data. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
chart is grayed out
It might be useful to know that I am running 2003 11.8169.8172 SP3
"rickhoff" wrote: I have one spreadsheet where, whenever I am working in cells, the chart turns into a big gray square. If I click anywhere in the chart, it reappears, but then goes back to gray as soon as I click a cell. I have never seen this before. Any ideas about how/why and what I can do to fix it? It's pretty complex and I would rather not redo it from the source data. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
chart is grayed out
Hi,
Make sure you have the setting Show all objects as it sounds like you have Show placeholders set. Use Tools Options View Show all objects. Cheers Andy rickhoff wrote: I have one spreadsheet where, whenever I am working in cells, the chart turns into a big gray square. If I click anywhere in the chart, it reappears, but then goes back to gray as soon as I click a cell. I have never seen this before. Any ideas about how/why and what I can do to fix it? It's pretty complex and I would rather not redo it from the source data. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
chart is grayed out
Andy
That was it!!! I have no idea how that option got tripped. Thanks!! rh "Andy Pope" wrote: Hi, Make sure you have the setting Show all objects as it sounds like you have Show placeholders set. Use Tools Options View Show all objects. Cheers Andy rickhoff wrote: I have one spreadsheet where, whenever I am working in cells, the chart turns into a big gray square. If I click anywhere in the chart, it reappears, but then goes back to gray as soon as I click a cell. I have never seen this before. Any ideas about how/why and what I can do to fix it? It's pretty complex and I would rather not redo it from the source data. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My chart is not showing; it's all grayed out. | Charts and Charting in Excel | |||
Autofilter grayed out - why? | Excel Worksheet Functions | |||
Urgent - How to fix grayed out option under Tools|Options|Chart? | Excel Discussion (Misc queries) | |||
grayed out | Excel Discussion (Misc queries) | |||
chart grayed out | Charts and Charting in Excel |