How to get the Chart Data Range without navigating through series collection using Excel VBA

[suresh_edk]

How to get the Chart Data Range without navigating through series collection using Excel VBA.
The Chart Data Range is the value that can be seen when we click SELECT DATA on the chart.

 

[Andrew Poulsom]

Welcome to MrExcel.

There isn't a property that returns a Chart's Data Range. As far as I know using the Series collection is the only way to get it.

 

[suresh_edk]

Thank you for the clarification sir...
I will try to get Chart data range from Series collection as given below.

Sub ChartDataRange()
Dim series_rng As String, j As Long
For j = 1 To ActiveChart.SeriesCollection.Count
series_rng = ActiveChart.SeriesCollection(j).Formula
sCollection = sCollection & "Series " & j & " - " & Split(series_rng, ",")(2) & vbCr
Next
MsgBox sCollection
End Sub