Is it possible to ask a chart which worksheet its data lives on?

  • Thread starter Thread starter Chrisso
  • Start date Start date
C

Chrisso

Hi All

Is it possible through VBA to ask a chart for the name of the
worksheet where it is sourceing 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 acheive 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
 
You can parse the series formula of each series to find where its data
resides. John Walkenbach has a class module that does the heavy lifting for
you:

http://www.j-walk.com/ss/excel/tips/tip83.htm

Find the range containing a series' X or Y values, then determine the parent
of that range.

- Jon
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I ask a chart where its data comes from? 2
Can you ask a chart which worksheet it's data is located? 1
Copying embedded charts 1
Abstracting Error Bar Data From Charts 3
how to copy sheet with charts without link to original data 6
Force charts to refresh? 2
Chart Relative To Worksheet When Copying- Excel 2007 1
Data Limit on Bar Chart? 1

Back
Top