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..

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


On Mar 22, 9:18 am, "BINZA@" <mark1.smith(remove this)@virgin.net>
wrote:
> 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..

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

thanks.
<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>
> On Mar 22, 9:18 am, "BINZA@" <mark1.smith(remove this)@virgin.net>
> wrote:
>> 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..
>
>

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

On Mar 22, 1:01 pm, "BINZA@" <mark1.smith(remove this)@virgin.net>
wrote:
> Ken,
> Its not protected and where is the data series you mention?
>
> thanks.<krco...@aol.com> wrote in message
>
> news:(E-Mail Removed)...
>
>
>
> > 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
>
> > On Mar 22, 9:18 am, "BINZA@" <mark1.smith(remove this)@virgin.net>
> > wrote:
> >> 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..- Hide quoted text -
>
> - Show quoted text -