title: Named ranges in google spreadsheet charts?
body: <p><strong>Edit:</strong> This question relates to the "old" google spreadsheets that were current in 2013.</p>
  
  <p>Is it possible to use <strong>named ranges in google spreadsheet charts</strong>? </p>
  
  <p>I need to dynamically update the dimension (starting position and size) of a range and be able to reflect it in a chart, i.e. I need the chart source range to <strong>follow</strong> the position of <strong>moved</strong> source data range.</p>
  
  <p><strong>Extra information:</strong></p>
  
  <p>I've got two sheets. One has a header followed by 'input' row and data rows. When I type anything into 'input' row my script automatically adds a row just after this one and moves my new input there, therefore creating new row of data. </p>
  
  <p>About chart: If I assign a data range that includes only data rows, new row won't be included because whole 'old' range got shifted. $ sign is ignored when specifying data range. So what I'm doing is to include in the range my 'input' + 1 header row. They have no values so in the chart you cannot see data points in the first two positions. I'm using a <strong>combo chart</strong> with another range from another sheet that has no header, so it looks like this:</p>
  
  <p><img src="https://i.stack.imgur.com/NYeIK.png" alt="enter image description here"></p>
  
  <p><em>(usually there is some value for the green histogram right at the origin of the chart)</em>.</p>
  
  <p>So the line chart is shifted by two positions to the right, but it should start from position 0, so I want the chart to somehow follow the range or to redefine it, so it always stars from the first data row. I hope it makes sense.</p>