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
Bookmarks