retreiving the range of a graph

[Arne]

I have a number of X,Y-charts on a worksheet, which represent data on another
sheet in the same workbook. How can I establish (using VBA, of course) which
range corresponds to each series of a chart? TIA,

Arne

[Kaak]

ChartString = ActiveChart.SeriesCollection(1).Formula

[Tushar Mehta]

In article <[email protected]>,
[email protected] says...
> I have a number of X,Y-charts on a worksheet, which represent data on another
> sheet in the same workbook. How can I establish (using VBA, of course) which
> range corresponds to each series of a chart? TIA,
>
> Arne
>
Adapt John Walkenbach's code at
http://www.j-walk.com/ss/excel/tips/tip83.htm

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

[Arne]

Ah, thanks!

"Tushar Mehta" wrote:

> In article <[email protected]>,
> [email protected] says...
> > I have a number of X,Y-charts on a worksheet, which represent data on another
> > sheet in the same workbook. How can I establish (using VBA, of course) which
> > range corresponds to each series of a chart? TIA,
> >
> > Arne
> >
> Adapt John Walkenbach's code at
> http://www.j-walk.com/ss/excel/tips/tip83.htm
>
> --
> Regards,
>
> Tushar Mehta
> www.tushar-mehta.com
> Excel, PowerPoint, and VBA add-ins, tutorials
> Custom MS Office productivity solutions
>

[Tushar Mehta]

In article <[email protected]>,
[email protected] says...
> Ah, thanks!
>
You are welcome.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions