View Single Post
  #2   Report Post  
P Sitaram
 
Posts: n/a
Default

Use the Add method of SeriesCollection to add the range:

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