title: Named Range in Excel Graphs
body: <p>I have a named range that uses an offset formula to define a dynamic range. The offset formula works correctly (i.e. when I go into the Name Manager and click on the name/formula it highlights/references exactly what I want it to). The formula is named RANGE and is shown below:</p>
  
  <pre><code>  =OFFSET(INDIRECT('Sheet1'!$B$2),0,0,'Sheet1'!$F$6+1,1)
  </code></pre>
  
  <p>The issue I am having is using it in a graph as one of my data series. I have tried both of the following when defining the series values and neither work. I have tried Ctrl+Shift+Enter after entering what is below thinking it may have to do with Excel not recognizing it as an array, but that also did not work.</p>
  
  <pre><code>   ='Workbook Name.xlsm'!RANGE
     ='Sheet1'!RANGE
  </code></pre>
  
  <p>I feel like I am missing something obvious. This should not be that difficult.... Thanks in advance for your help.</p>