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
Bookmarks