Cannot Use Array of Data Points with Extend Method

MORE INFORMATION

In Microsoft Excel, you can use the Extend method to add new data points to an existing series in a chart. For example, if you create a simple column chart that contains a single series, and you want to add new data points to the series, you can use a line of code similar to the following:

   ActiveChart.SeriesCollection.Extend Worksheets("Sheet1").Range("B5:B6")
				

This line of code adds the values in cells B5:B6 in Sheet1 to the chart.

If you specify an array of data points for the Source argument of the Extend method, you receive an error message. For example, the following sample code causes the problem:

   Dim xExtras
   xExtras = Array(2, 3, 5, 7)
   ActiveChart.SeriesCollection.Extend xExtras
				

The problem occurs because xExtras refers to an array of data points, not to a Range object.