title: VBA Paste Special on Existing Chart
body: <p>I would like to use VBA to paste a range of data into an existing chart, using the options shown in the following screenshot:</p>
  
  <p><img src="https://i.stack.imgur.com/r7HyO.jpg" alt="enter image description here"></p>
  
  <p>If I record a macro whilst doing so manually, the code only states <code>ActiveChart.Paste</code>. Thus, when I re-run this code the series is pasted regularly without the 'Series Name In First Row' deactivated. How can I code this correctly? I haven't found much in the way of help in my research so far.</p>