title: Dynamic chart range using INDIRECT: That function is not valid (despite range highlighted)
body: <p>I'm trying to create a chart with a range built dynamically using the <code>INDIRECT</code> function. Excel does recognize the range I am creating using <code>INDIRECT</code> as it highlights the corresponding range on the sheet:</p>
  
  <p><img src="https://i.stack.imgur.com/Plhtz.png" alt="enter image description here"></p>
  
  <p>However when saving the chart, I get an error message saying the function is not valid:</p>
  
  <p><img src="https://i.stack.imgur.com/m3bqc.png" alt="enter image description here"></p>
  
  <p><strong>Does anybody know what the problem is / how to create a dynamic chart range from a specific start to specific end point?</strong></p>
  
  <p>PS: <a href="http://wikisend.com/download/445302/test_dynamic_chart_range_with_indirect.xlsx" rel="noreferrer">You can download the above spreadsheet here</a>. The formula I was using:<br>
  <code>=INDIRECT("sheet!"&amp;E2&amp;":"&amp;E3)</code></p>