Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding Source of Chart Data
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 *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pie chart & column chart w/same source data | Charts and Charting in Excel | |||
Excel chart source data y-values can only accept 7 data pts? | Charts and Charting in Excel | |||
Use detailed data in one worksheet to create summary data as chart source | Charts and Charting in Excel | |||
How do you link chart source data when you copy the chart? | Charts and Charting in Excel | |||
Update a chart immediately after inputting data into data source | Charts and Charting in Excel |