Finding Source of Chart Data

B

Bill

Hello,
I would like to be able to, from a chart, find the worksheet containing
the data used to make the chart. Is there a way to do this? I can get
the formula that contains the name of the worksheet, but I don't know if
that is consistent across versions of Excel. Plus I guess I can find
the location of "," and then "!" and the name would be stuff in between.
Would that work with all versions of excel? Or is there a better way?

Thanks,

Bill



*** Sent via Developersdex http://www.developersdex.com ***
 

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

Export BPMN Visio Chart to Excel 0
Unreadable text when viewing organization chart in Web version of Visio 365 0
Filtered view of Visio Chart 0
Creating Network Diagram using a Chart SW integration 0
Doughnut Chart linked with the slicer in the pivot table 0
Create a chart from a table in word thats dynamic 0
Creating a Chart on form from selected data in query. 0
Sharing Access MDB or Accdb with client using older or newer version of Office 1

Top