title: Excel Vba: limit on maximum number of data points across all charts?
body: <p>I writing code to produce about 7 charts in Excel Vba. There are many data points involved. I can produce about 5 charts until I get the error <strong>Run-time error 1004: The maximum number of data series per chart is 255</strong>.</p>
  
  <p>This error occurs at the line</p>
  
  <pre><code>Set mychart = Activeworkbook.Charts.Add
  </code></pre>
  
  <p>This is interesting because I do not have any charts with more than 3 data series. Further, like I said, I can make any combination of charts that is less than the total. 
  It seems like there's a limit on the number of total data points being used across all charts.</p>
  
  <p>Thanks.</p>