P Sitaram

Thanks for replying.

Your post put me on the right tack and have now completed my project.

Thanks

Alex

"P Sitaram" wrote:

Use the Add method of SeriesCollection to add the range:

ActiveChart.SeriesCollection.Add source:=Sheets("Feb 05").[A1:A10]