C
cell division
If I build a simple chart in Excel by selecting a range of cells, when
right-click on the chart and bring up the 'Source Data' menu, there's
tab called 'Data Range' that provides, in one convenient field, th
range of data for the entire chart. The 'Series' tab provides mor
detailed information, but the entire range is what I'm interested i
for now.
My problem is that I can't find a convenient way to access that piec
of information through VBA. I can retrieve bits and pieces, includin
individual data series values from the SeriesCollection... I can eve
change the data in 1 shot by doing something like:
charts(1).SetSourceData Source:=sheets(1).Range("A1:A10")
but I can't find any convenient way to get the entire range that
chart is referencing. Essentially, I want to know what that range wa
that I selected when I built the chart in the first place.
As always, any help is very much appreciated. Thanks,
- Ro
right-click on the chart and bring up the 'Source Data' menu, there's
tab called 'Data Range' that provides, in one convenient field, th
range of data for the entire chart. The 'Series' tab provides mor
detailed information, but the entire range is what I'm interested i
for now.
My problem is that I can't find a convenient way to access that piec
of information through VBA. I can retrieve bits and pieces, includin
individual data series values from the SeriesCollection... I can eve
change the data in 1 shot by doing something like:
charts(1).SetSourceData Source:=sheets(1).Range("A1:A10")
but I can't find any convenient way to get the entire range that
chart is referencing. Essentially, I want to know what that range wa
that I selected when I built the chart in the first place.
As always, any help is very much appreciated. Thanks,
- Ro