title: Dynamically Change Range in Excel Chart Without VBA?
body: <p>I'm charting values and I need to change the start and stop of the range dynamically. The chart is plotting from a sheet that has data for 5 forecast days. Each line in the chart represents a forecast day. Every day new data is added to the sheet, so there are more entries for each forecast day. Here is an example: </p>
  
  <p><strong>=SERIES("Day 4",sheet!$B$2:$B$49,sheet!$F$147:$F$193,5)</strong></p>
  
  <p>I need Excel to find the start and stop row numbers for each forecast day and change them every time there is new data. So the range for forecast day 4 $F$147:$F$193 will change to $F$148:$F$194, etc. </p>
  
  <p>Is it possible to do this in a formula? I really don't want to mess with VBA if I can avoid it.</p>