Hi All,

I have a chart with one SeriesCollection. I want to get the range of cells for Y-Axis and X-Axis for this chart using VBA.
The Series object has 'Values' and 'XValues' properties that return the values in an array.
Is there any way that I can get the range of cells (cell addresses) for the Series?
Or is there a way to get the range address on the worksheet from the array values?
Thanks in advance