My graphing facility in Excel '10 has greyed out and stopped responding!!

[thetalldude]

Hi all,

For some reason, one of my excel files (only one) has stopped letting me graph my data!!?? I have no idea what I've done to it.

When I go to the "Insert" tab, the 'Illustrations' and 'Charts' sections are greyed out (as if to say 'in-accessible') and I can't make a graph. All other facilities in this Excel file seem to be working fine, and all the other files haven't got this problem at all.

Any ideas? I'm sure its a one click solution, but I'm stuck!...

[vlady]

Hello try this.

Go to file--option-advanced
scroll down to "Display"
below you'll see "Display option for this workbook"
under that is a radio button with
For objects, show

"All" check if that is active
click ok.

[thetalldude]

Vlady you have absolutely solved my problem in tens second flat!!

Thank you very much!! That would have taken me a life time to figure out.

Cheers

[vlady]

your welcome.