Can you ask a chart which worksheet it's data is located?
 

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

Can you ask a chart which worksheet it's data is located?
 

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" wrote in message
ps.com...
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