Charts disabled in Excel 2007 ribbon

[Jeff Reese]

Hello.

I am using Excel 2007.

I have a file that had multiple charts in it. When I recently opened it,
all of my charts had vanished. Also, If I try to build new charts, I
highlight the appropriate date but all of the chart options in the ribbon are
grayed out - I can't select one.

Additionally... I have try to copy a chart from another excel file into
this problem file it tells me "Microsoft Office Excel cannot paste the data".

Note, that I can create charts in other Excel files, just not this
particular one.

Any ideas what is causing this? I have a lot of charts in this file and
don't want to recreate them...

Thanks.

 

[Bob Umlas, Excel MVP]

Sounds like you have the setting to not display objects on the sheet (a chart
is an object)-- you probably can't add a rectangle, either! Find the option
in Office/Excel Options.
Or easier, press ctrl/6 (not F6, 6).
Bob Umlas
Excel MVP

 

[Jeff Reese]

Bob, this solved the problem.

Thanks!

--
Jeff

Sounds like you have the setting to not display objects on the sheet (a chart
is an object)-- you probably can't add a rectangle, either! Find the option
in Office/Excel Options.
Or easier, press ctrl/6 (not F6, 6).
Bob Umlas
Excel MVP