krishnak
05-15-2015, 08:58 AM
Hi All,
I am creating a new chart sheet through VBA and I have two arrays for XValues and Values. For an embedded chart we can add a SeriesCollection and assign the array values for X and Y Axes.
For example -
SeriesCollection(1).XValues = xArr
SeriesCollection(1).Values = yArr
For a blank chart sheet, how do we add a new SeriesCollection and assign values through arrays as above?
The documentation for chart sheets says only about SetSourceData method for which the source is a Range.
Any assistance is appreciated.
I am creating a new chart sheet through VBA and I have two arrays for XValues and Values. For an embedded chart we can add a SeriesCollection and assign the array values for X and Y Axes.
For example -
SeriesCollection(1).XValues = xArr
SeriesCollection(1).Values = yArr
For a blank chart sheet, how do we add a new SeriesCollection and assign values through arrays as above?
The documentation for chart sheets says only about SetSourceData method for which the source is a Range.
Any assistance is appreciated.