title: How do you graph using Rows instead of Series?
body: <p>I'm doing a VBA Excel code which graphs certain data, yet the limit of 225 data series keeps showing up even when it was specified to plot by rows, how can this be fixed?</p>
  
  <pre><code>Y=1197
  Set DChart = Charts.Add
     With DChart
        .ChartType = xlXYScatterSmoothNoMarkers
        .SetSourceData Source:=Sheets("Sheet1").Range("A2:" &amp; "B" &amp; Y), PlotBy:=xlRows
     End With
  </code></pre>