Using Pivot Table Groups/Rows for separate chart series

Hey,

I'm running Excel 2010 on Windows 7 64bit SP1. I have a Pivot Table that looks like the following:

• First Row Label is a person's name
• Second Row Label is a date
• The values column I have for these dates and people are a count of events

This means I can see for each person how many events they did on each date.

Pivot Table: I29Lufq.jpg

When I create a line Pivot Chart of this data I only have a single series shown on the chart with a Y axis of count, an X axis of date and the line drawn from the 'count of events' values across all of my people and dates.

Current Outcome:
sP6mgSA.jpg

What I'd like the Pivot Chart to do is make each of the top level Row Labels (i.e. the person) a separate series in the chart. This way over the same period of time I can trend each person. I'm wondering, is there a way to do this by default? Right now I can do it by manually defining each series and the X axis myself, but as I scale up to lots of people this will become a massive time sink. Is it possible to define a series by Group or Row Label?

Desired outcome:
oI4Xfui.jpg

Thanks

Hey,

I've attached a sample copy of the table.

Thanks

Excel Pivot Test.xlsx