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?

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?

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?