title: Excel 2010 VBA.. Adding series to existing chart
body: <p>I am currently trying to populate a chart with data where the user can simply press the button on the spreadsheet. The issue I am having is I need the button to copy data to a data sheet and then the chart will populate from the data sheet. I can do this, but I need a new series created on the chart for every new data that is ente</p>
  
  <pre><code>Sub RoundedRectangle2_Click()
  
  End Sub
  
  
  Sub MAPS()
  Sheets("MAPS_FORM").Range("e47").Copy
  Sheets("Data_Sheet").Range("b65536").End(xlUp).Offset(1, 0).PasteSpecial _
  Paste:=xlPasteValues
  Application.CutCopyMode = False
  Sheets("MAPS_FORM").Range("d2").Copy
  Sheets("Data_Sheet").Range("a65536").End(xlUp).Offset(1, 0).PasteSpecial _
  Paste:=xlPasteValues
  Application.CutCopyMode = False
  
  
  
  Sheets("Data_Sheet").Range("b2:b46").Copy
  Charts("Chart1").SeriesCollection.Paste
  
  Range("e6:i8").ClearContents
  Range("e12:i19").ClearContents
  Range("e23:i27").ClearContents
  Range("e31:i36").ClearContents
  Range("e40:i43").ClearContents
  Range("d2").ClearContents
  Sheets("Data_Sheet").Select
  End Sub
  </code></pre>