Hi All

Is it possible through VBA to ask a chart for the name of the
worksheet where it is sourcing its data?

I have one worksheet with all my charts. Each chart refers to data on
a seperate sheet - one per chart.

I would like to loop through each ActiveSheet.ChartObjects and find
the worksheet where the data lives - I then intend to update it based
on user criteria.

I cannot see how to achieve this through the object model. Is this
possible? I suppose it may not be as a chart may have data from
multiple worksheets.

Thanks for any ideas in advance,
Chrisso

See the thread in the charting group.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Chrisso" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi All
>
> Is it possible through VBA to ask a chart for the name of the
> worksheet where it is sourcing its data?
>
> I have one worksheet with all my charts. Each chart refers to data on
> a seperate sheet - one per chart.
>
> I would like to loop through each ActiveSheet.ChartObjects and find
> the worksheet where the data lives - I then intend to update it based
> on user criteria.
>
> I cannot see how to achieve this through the object model. Is this
> possible? I suppose it may not be as a chart may have data from
> multiple worksheets.
>
> Thanks for any ideas in advance,
> Chrisso
>