Getting Range from selected Chart

[dinosaur_uk]

Hi there!

I am a newbie in VBA and i am desperately trying to understand how the charting works in excel.

I want to detect the data behind a selected chart.

Dim Charty As Chart
Dim sel As SeriesCollection
Dim ser As Series
Dim rng As Range

Set Charty = Application.ActiveChart
Set sel = Charty.SeriesCollection(1)

How do i get the range of the chart?

[westconn1]

try sel.formula