chart links

[BINZA@]

I have an excel workbook that consists of several sheets and 4 of these
sheets are charts, i am wondering if its possible to see where the source
cells are that drive the chart columns.
I know they are not external they are all within the workbook.
The chart button at top only lists greyed out buttons when in the chart
sheets.

Any help appreciated..

 

[krcowen]

Binza

You see grayed out options under chart when the chartsheet is
protected. Even when protected, you can still see the source of data
when you click on the data series. You can't change the source when
it is protected, but, at least you can see where it is coming from.
That could be your situation.

Good luck.

Ken
Norfolk, Va

 

[BINZA@]

Ken,
Its not protected and where is the data series you mention?

thanks.

 

[krcowen]

If it is not protected, then my theory is incorrect. If you click on
the data on the chart, you should see the source of the data in the
formula bar.

Ken