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?