Results 1 to 4 of 4

Using Pivot Table Groups/Rows for separate chart series

Threaded View

AntiPop Using Pivot Table Groups/Rows... 07-04-2013, 06:14 AM
dilipandey Re: Using Pivot Table... 07-04-2013, 07:43 AM
AntiPop Re: Using Pivot Table... 07-04-2013, 10:12 AM
dilipandey Re: Using Pivot Table... 07-09-2013, 06:40 AM
  1. #1
    Registered User
    Join Date
    07-04-2013
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    3

    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
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1