Getting range from a chart series

[ErikJan]

To get the y-range from a chart series, do I have to eliminate that from this:

Sheets(Ch_Name).SeriesCollection(i).formula

Or is there a direct method to get to X and Y range?

[HansV]

You have to parse the Formula (or FormulaR1C1) property of the series. Although you can set the XValues and Values properties of the series to a range, the result is always an array.