title: Excel: filtering a time series graph
body: <p>I have data that looks like the following:</p>
  
  <pre><code>ID      | Location | Attendees | StartDate | EndDate
  ---------------------------------------------
  Event1  | Bldg 1   | 10        | June 1    | June 5
  Event2  | Bldg 2   | 15        | June 3    | June 6
  Event3  | Bldg 1   | 5         | June 3    | June 10
  </code></pre>
  
  <p>I'd like to create a time series graph showing, for every given date, how many events were active on that date (i.e. started but haven't ended yet). For example, on June 1, there was 1 active event, and on June 4, there were 4 active events.</p>
  
  <p>This should be simple enough to do by creating a new range where my first column consists of consecutive dates, and the second column consists of formulas like the following (I hardcoded June 8 in this example):</p>
  
  <pre><code>=COUNTIFS(Events[StartDate],"&lt;=6/8/2009", Events[EndDate],"&gt;6/8/2009")
  </code></pre>
  
  <p>However, the challenge is that I'd like to be able to <strong>dynamically filter</strong> the time series graph based on various criteria. For example, I'd like to be able to quickly switch between seeing the above time series only for events in Bldg 1; or for Events with more than 10 attendees. I have at least 10 different criteria I'd like to be able to filter on.</p>
  
  <p>What is the best way to do this? Does Excel have a built-in way to do this, or should I write the filtering code in VBA?</p>