Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart Source Data
Hello Again, I did not get a response the first time I posted this question. The first time that has happened. Perhaps it is more difficult than I think. I would like to find, using VBA, the worksheet containing the data for a chart - beginnig with the chart being active sheet. Is there an easy way to do that? Thanks, Bill *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart Source Data
Hi Bill,
Need to parse a series formula. If all you want is the source worksheet maybe this (barely tested and likely unreliable in all but 'typical' scenarios) Sub test() Dim sFml As String Dim sShtName As String Dim v sFml = ActiveChart.SeriesCollection(1).Formula v = Split(sFml, ",") sShtName = Replace(Left(v(2), InStr(v(2), "!") - 1), "'", "") MsgBox sShtName ' Split & Replace n/a in xl97 End Sub For more info on the series formula and infinately more reliable code http://www.j-walk.com/ss/excel/tips/tip83.htm Regards, Peter T "Bill" wrote in message ... Hello Again, I did not get a response the first time I posted this question. The first time that has happened. Perhaps it is more difficult than I think. I would like to find, using VBA, the worksheet containing the data for a chart - beginnig with the chart being active sheet. Is there an easy way to do that? Thanks, Bill *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation to range names for Chart Source Data | Charts and Charting in Excel | |||
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 |