title: Set Excel chart data series range dynamically by a cell's value
body: <p>I have a simple chart in Excel where I plot 2 data series referring to a 3rd one.</p>
  
  <p>What I want to do is to change the range of one of the first data series based on a number in a cell. For example if the number is 1 and the data series is in column A the range of the chart should be <code>A1:A100</code>. Now if I change the number to 10 the chart range should be <code>A10:A100</code>.</p>
  
  <p>This doesn't seem hard but I cant figure it out. I've been searching StackOverflow and the web for a long time but I couldn't find anything that seems to solve my problem.</p>
  
  <p>Thanks in advance to everyone who can help!</p>