krishnak
08-17-2012, 08:31 AM
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
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