Getting Range from selected Chart

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.

Code:

---

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?

try sel.formula