This part of my macro stops at line 6 below, where it throws up a runtime error...
There is no reason why it wont work as its an exact cope of line 2, but references the next column in a spreadsheet nd is for n additional series..
any ideas?
ActiveChart.SeriesCollection.NewSeries...