Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find source WS from Chart
I have a case where I want to branch code when a user clicks on a Toolbar
button when a chart is the active sheet. I want to find out where the source data from the chart is coming from. My initial thought was to use .XValues, and branch my code based on the location of the source data. When I have the Chart Active, and go to the Chart Menu and select Source Data, I get a dialog where I can clearly see the chart knows exactly where the data is coming from. If I turn on recording, and manipulate that window, nothing gets recorded. However, in VBA, when I grab a series, and look as .Values or .XValues, it returns a variant array. So far, the only way I have been able to determine the worksheet the .XValues came from is to get Series.Formula, and actually parse the name out of the string. Is there a better way of determining where the source data from a chart (or series really) is coming from? Thanks, Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find/edit combo box source? | New Users to Excel | |||
pie chart & column chart w/same source data | Charts and Charting in Excel | |||
How do you link chart source data when you copy the chart? | Charts and Charting in Excel | |||
How to find a query source | Excel Worksheet Functions | |||
find out line count source in vbe | Excel Programming |