title: Clamp/filter data set used for Excel chart
body: <p>In Excel 2010, consider a set of data values ranging from M to N. These values are used to display a chart. Now, let's say I want to skip values that match certain criteria. How would I do that?</p>
  
  <p>E.g. Column $A contains values ranging from 0 to 100, but I want to skip values below the value of $E$1 and values above the value of $E$2. Hence, something like "Get all values from column A, remove all values below $E$1 and above $E$2 and then plot a chart of the remaining values!"...</p>
  
  <p>I'm trying to improve the solution marked as answer <a href="https://stackoverflow.com/a/9599645/419776">here</a>.</p>