title: Using named "Chart Data Ranges"
body: <p>I am trying to build a chart which dynamically updates the series' selected based on user-defined selections from a drop-down menu. </p>
  
  <p>Purpose is to create chart which displays n-series of data based on n-selections, e.g.</p>
  
  <p><code>=Output!$P$36:OFFSET(Output!$O$35,IF(Output!$C$4="RANK",COUNT(Output!$S$34:$S$38),COUNT(Output!$S$34:$S$38)+3),COUNTA(Output!$P$35:$W$35))</code></p>
  
  <p>The named range dynamically updates the chart area (i.e. row labels, column labels and data range). I reference it correctly i.e. as <code>='filename.xlsm'!named_range_here</code> in the "Chart Data Range" section.</p>
  
  <ol>
  <li>When I do this, the Chart Data Range resets itself [help]</li>
  <li>How can I tell excel to stop showing blank series (e.g. 2 blank series of 5 when i want it to display the 3 series which have values) [ideas please]</li>
  </ol>