title: Google Sheet Chart's Data Range (in Chart Editor) formula from cell value
body: <p>I have a chart in Google Sheets, the &quot;Data Range&quot; is as follows...</p>
  <pre><code>MIR!J1:K4547,DIR!K1:K4547
  </code></pre>
  <p>What I am trying to do is reference a cell value for sheet &quot;MIR&quot; and &quot;DIR&quot; values.</p>
  <p>Let's say I edit cell A1 to ZIR...</p>
  <p>then the data range changes to</p>
  <pre><code>ZIR!J1:K4547,DIR!K1:K4547
  </code></pre>
  <p>I searched intensively in Google but maybe I am not using right keywords, will appriciate some feedback on this...</p>