title: chart in excel with user data selection
body: <p>I have data like this:</p>
  
  <pre><code>    Date         1st var     2nd var      ....  nth var    benchmark
    01.01.1999      1.1         2.03                3.1          1.7
    05.01.1999      1.2         2.01                3.07         1.5
  </code></pre>
  
  <p>I need to do the following: I want to plot one of the variables and the benchmark on the same chart. But I need a possibility of selecting variable and date range, so chart would auto-update. Selection may be done by entering limits in cells, or selecting from drop-down lists.</p>
  
  <p>For now column length is fixed (somewhere around 1500 values). But after doing this, I am planning on making it auto-update when a new row of data is inserted.</p>
  
  <p>I am new to excel and know a little of VBA. I plotted two graphs on one chart using excel chart manager but I don't know how to (or is it even possible) add data selection.</p>
  
  <p>1) Is it possible to do this only using excel built-in functions? If yes, should I do this within excel or VBA? Which way is better?</p>
  
  <p>2) If writing an answer is too long or the best method would be too complicated for me to understand, could you please advise me a reference to read?</p>
  
  <p>Thanks a lot!</p>