VBA- SeriesCollection

Y

yusoon

This code gives me run-time error : '438' object doesn't support thi
property or method

Worksheets("sheet1").ChartObjects("Chart 1").Chart. _
SeriesCollection(1).Value = "=Sheet1!R1C1:R20C1
 
K

Klaus

It is really simple:
Worksheets("sheet1").ChartObjects("Chart 1").Chart. _
SeriesCollection(1).Values = "=Sheet1!R1C1:R20C1"

The s at value --> values is missing

Regards
Klaus
 
Top