Hi, i have a chart on a worksheet, it contains multiple series (3) in which i wish to change the values/range of each series of the chart through vba. Thus far i have struggled due to the lack of intellisense, in which i tried

Worksheets(1).ChartObjects(2).Chart.Series("Fails").Values = Range("b12:b14")

with "Fails" being the name of that particular series.

any ideas?

cheers