If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
charts
I inherited a multipage workbook with data and charts. Many of the charts do
not allow me to access the chart options (data source, formatting, etc.). They are not protected, but the chart options simply are not available (the menu bar does not change from worksheet options to chart options). How do I gain access to modify the charts? |
#2
|
|||
|
|||
There is a good chance that these are not really charts but pictures of
charts. A lot of people will copy a chart as a picture and paste it in the page so that they have a record of what they saw. also it someone is reorganizing the data the charts do not change if they were made a picture. "LeeAnn" wrote: I inherited a multipage workbook with data and charts. Many of the charts do not allow me to access the chart options (data source, formatting, etc.). They are not protected, but the chart options simply are not available (the menu bar does not change from worksheet options to chart options). How do I gain access to modify the charts? |
#3
|
|||
|
|||
What dialog box do you get when you double click the object? Is it
'Format Picture?' If so, as bj pointed out, it is not a chart but a static image of a chart. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I inherited a multipage workbook with data and charts. Many of the charts do not allow me to access the chart options (data source, formatting, etc.). They are not protected, but the chart options simply are not available (the menu bar does not change from worksheet options to chart options). How do I gain access to modify the charts? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Why did Pivot table charts copied into workbook with standard cha. | TamaJo | Charts and Charting | 1 | October 26th, 2004 01:53 AM |
How to Make Pie Charts the Same Size | Jon Peltier | Charts and Charting | 0 | May 3rd, 2004 09:34 PM |
Distribute dynamically charts with linked data as stand-alone charts | Richard | Charts and Charting | 2 | March 31st, 2004 05:16 PM |
charts inadvertly resized | Hammer_757 | Charts and Charting | 0 | March 24th, 2004 02:16 AM |
Creating a large number of charts automatically (repost) | Francine Kubaka | Charts and Charting | 0 | September 21st, 2003 09:16 PM |