+ Reply to Thread
Results 1 to 7 of 7

different series based upon filters (pivot charts)

  1. #1
    Registered User
    Join Date
    08-23-2012
    Location
    Omaha, NE
    MS-Off Ver
    MS 365
    Posts
    58

    different series based upon filters (pivot charts)

    I have a pivot table that shows service desk metrics (help desk). I can see average time to resolution per incident. Each incident has who was assigned to it. I can build out a pretty graph that shows me average time to resolution for all incidents in a time period. However, I want to create a different series (line graphs) for each manual grouping of person that was assigned the ticket by which level they are (level1, 2 or 3)

    For example:
    Level 1 = John, Mike, Sarah,
    Level 2 = Joe, Shawn, Alice
    Level 3 = Mark, Jim, Greg

    I want a series (different line on the line graph) for level 1, level 2, and level 3. The data does not have any way for me to tell which level a person is, which is why I'm thinking some sort of filter.

    Thoughts?

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    7,124

    Re: different series based upon filters (pivot charts)

    This will depend very much on how the source data looks. Often a pivot table issue can be solved by adjusting the source data with helper columns.

  3. #3
    Registered User
    Join Date
    08-23-2012
    Location
    Omaha, NE
    MS-Off Ver
    MS 365
    Posts
    58

    Re: different series based upon filters (pivot charts)

    I could certainly do that but this data is going to be imported monthly so want to handle this in the pivot. I don't have any data that suggests which level the people are. That is why I want to do some sort of custom field or manual filtering/grouping of people in the pivot.

  4. #4
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    7,124

    Re: different series based upon filters (pivot charts)

    How are you importing it? If you are using MS-Query, the data comes in as an Excel Table. If you copy and paste it, you can copy and paste it into an Excel table. One of the things Excel tables do is remember formulas and copy them down the range automatically.

    This will give you an introduction to tables: http://www.utteraccess.com/wiki/inde...ables_in_Excel.

  5. #5
    Registered User
    Join Date
    08-23-2012
    Location
    Omaha, NE
    MS-Off Ver
    MS 365
    Posts
    58

    Re: different series based upon filters (pivot charts)

    Oh good point. I could put the helper columns at the end so my paste won't stomp on them.

  6. #6
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: different series based upon filters (pivot charts)

    Show how could look like the sample data and hand-drawn graph.
    It is possible that it can be achieved in excel using Power Query.

  7. #7
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    7,124

    Re: different series based upon filters (pivot charts)

    Exactly! I don't know how I lived before Tables came along.

    If you want some code to put behind a button to clear out the old data, here it is:
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Combining report filters on Pivot Charts
    By Adamlee in forum Excel General
    Replies: 12
    Last Post: 08-31-2015, 08:11 AM
  2. [SOLVED] Horizontal left and right bar charts based on different data series
    By meiselsan in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-18-2015, 09:12 AM
  3. [SOLVED] Is it possible to dynamically update a charts data series, based on another cell
    By missydanni in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-14-2013, 11:29 AM
  4. Changing the Pivot Table Filters based on Multiple Cells
    By dbnhc8 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-28-2012, 02:37 PM
  5. Multiple Pivot Charts w/ different filters
    By jablo1312 in forum Excel General
    Replies: 0
    Last Post: 06-21-2012, 01:28 PM
  6. Replies: 1
    Last Post: 06-17-2005, 05:22 AM
  7. Pivot Charts, hiding field values in second level filters?
    By elrao in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-17-2005, 05:19 AM

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