Set SeriesCollection(1).Values = Range("A1")

In Microsoft Excel 95, you could assign a worksheet range directly to a chart series. The relevant code might say:

Set ActiveChart.Series(1).Values = wSheet1.Range("A1:A10")

This line of code will not work in Microsoft Excel 97. Instead, assign the range to an array, and then assign the array to the chart series.

adData = Array(ThisWorkbook.Sheets("Sheet1").Range("A1:A10"))
Set ActiveChart.Series(1).Values = adData