graphs

[tinylawu]

I've recorded a marco doing some simple graph. So how that it works perfect but whenever I close the file and start again it just won't work. when I debug it the same line always wrong.
here is the macro.
ActiveChart.SeriesCollection(2).Values = "=MAIN!R25C16"
Thanks.

 

[Corni]

According to your line of code, the SeriesCollection method returns only one value. Usually the series include more than one value, expressed as a range.