Charts disabled in Excel 2007 ribbon
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. -- Jeff |
Charts disabled in Excel 2007 ribbon
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" wrote: 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. -- Jeff |
Charts disabled in Excel 2007 ribbon
Bob, this solved the problem.
Thanks! -- Jeff "Bob Umlas, Excel MVP" wrote: 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" wrote: 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. -- Jeff |
All times are GMT +1. The time now is 05:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com