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?