title: Excel pie charts from pivot table columns
body: <p>I have a pivot table from a database that looks something like this:</p>
  
  <pre><code>         Person A       Person B        Person C
  
  Task A      1                               3  
  Task B                      1               2 
  Task C      2               1.5             1
  </code></pre>
  
  <p>The number is time spent on a task.  If it's blank, the person didn't work on that task.  </p>
  
  <p>I would like to make a pie chart for each Person from the pivot table for time spent on each task, not including tasks where the cell is blank.  I've tried adding various flavours of pie charts but it only ever creates the chart on the first column of the table.  And when it does that, it seems to include empty cells in its key (though obviously not on the pie).  </p>
  
  <p>Does anyone know anything about this?</p>