title: Add multiple data series to excel chart with VBA
body: <p>Assuming I have my data in rows and I want to create a chart (x,y scatter) from it.</p>
  
  <pre><code>date    1.1. 1.2. 1.3. 1.4 1.5
  set1    12  36  12  23  33
  set2    44  22  11  1   13
  set3    54  5   56  56  34
  set4    1   2   6   12  33
  </code></pre>
  
  <p>how can I add set1,set2 and set4 but not set3 to the chart without having to select them individually one after another?</p>
  
  <p>For the x-range (date) I can do</p>
  
  <pre><code>Dim xrange As Range
  Set xrange = Application.InputBox("select x-range", "Get Range", Type:=8)
  </code></pre>
  
  <p>But doing the same for the data sets (selection of multiple rows) won't work because each series in a scatter plot requires a individual range</p>
  
  <pre><code>   ActiveChart.SeriesCollection(1).XValues = xrange
     ActiveChart.SeriesCollection(1).Values = "=Sheet1!$4:$4"
  </code></pre>
  
  <p>but I have a selection of multiple datasets. I would need a way to split the ranges from my input box selection(s) and to write them to unique variables. Then I would add a new series for each xrange + variable pair with the above method. </p>
  
  <p>Is there a wayto do this? </p>
  
  <p>A potentail answer does not need to stick to what I posted above, any suggestions are welcome. </p>