Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Not able to View, Modify, or Create Charts in Excel 2007

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 13-05-2011
Member
 
Join Date: Apr 2011
Posts: 44
Not able to View, Modify, or Create Charts in Excel 2007
  

Hello friends. Greetings to all of you. I have a macro-enabled 2007 excel spreadsheet which comprises both charts like objects in sheets in addition to charts as different sheets. Each and every of the charts were produced in Excel 2007, even though the novel data set was formed in 2003. A few are based off data in tables, in addition to few which are PivotCharts. In recent times, all the chart objects vanished and the charts on their individual sheets became "locked." Thus in the process, I am not able to View, Modify, or Create Charts in Excel 2007. Any suggestions then please help friends. Thanks.

Reply With Quote
  #2  
Old 13-05-2011
Member
 
Join Date: May 2008
Posts: 979
Re: Not able to View, Modify, or Create Charts in Excel 2007

Hey mate, why don?t you try out and make a new pivot chart. It may help you out in some way. In addition to what I told you, giving a try to open the file on another computer and checking out what happens won?t be a bad idea either. I can also imply you to save it as a macro-free workbook . Lat but not the least option will be saving it in 2003 format. I hope that out of all the alternatives which I have provided you, at least one helps out.
Reply With Quote
  #3  
Old 13-05-2011
Member
 
Join Date: Nov 2008
Posts: 1,054
Re: Not able to View, Modify, or Create Charts in Excel 2007

Hello my friend. I can guide you on this. As you have mentioned that you are not able to observe the chart objects, and they have grayed out , I would like to tell you that you should go to Insert and the Chart buttons can resolved by Office Button , then Excel Options , followed by Advanced , move on to Display and finally you will have to go to Display options for this workbook. For the case of objects, show, All. I hope this is fairly easy and there will be no harm in performing it.
Reply With Quote
  #4  
Old 13-05-2011
Member
 
Join Date: Nov 2008
Posts: 1,192
Re: Not able to View, Modify, or Create Charts in Excel 2007

Hello my friend. The probable reason of Grayed out Insert and Charts buttons can be for the reason that the worksheet is protected i.e. by saying that I mean go to Review , move on to Changes and then Unprotect Sheet otherwise since you have preferred multiple sheets ,you will be able to observe Group inside the title bar. There you will be required to Right-click a sheet tab and then select Ungroup sheets. I hope this helps.
Reply With Quote
  #5  
Old 13-05-2011
Member
 
Join Date: Nov 2008
Posts: 1,022
Re: Not able to View, Modify, or Create Charts in Excel 2007

Hello my friend. Just was surfing the internet and went through the thread. Looking at the replies, I hope that the issue has been resolved because I feel that sufficient solutions have already been mentioned. In any case, still it hasn?t, then I have one more alternative for you. It may be the reason that you have shared the workbook , you will be able to observe Shared in the title bar . Go to Review , followed by Changes and select Share Workbook and at last Editing and then uncheck the checkbox.
Reply With Quote
  #6  
Old 16-05-2011
Member
 
Join Date: Jun 2009
Posts: 1,518
Re: Not able to View, Modify, or Create Charts in Excel 2007

Hey friends, I am having the similar difficulty however the answers which have been specified did not help me. Following a little browsing all the way through several internet forums I was able to see "I have observed this previously and was capable to get chart sheets to come into view another time by being sure that there was some kind of default printer, and confirming the print authorization on that printer were not disabled."It indeed help me to a great deal.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Not able to View, Modify, or Create Charts in Excel 2007"
Thread Thread Starter Forum Replies Last Post
Excel 2007 charts are not updating at all Omkaari MS Office Support 2 24-01-2012 02:12 PM
How to create table and Modify tables in Microsoft Access 2007 Antonio1 Windows Software 7 27-11-2009 12:31 AM
Create a Schedule in Excel 2007 Computer_Freak Tips & Tweaks 0 07-04-2009 11:47 AM
How to find slope in Line Charts in Excel Amelia Windows Software 3 04-02-2009 03:25 PM
Bubble Charts in PowerPoint 2007 Nickason MS Office Support 2 08-05-2008 04:46 AM


All times are GMT +5.5. The time now is 01:57 PM.