Results 1 to 3 of 3

Thread: Dates in Multiple Series

  1. #1
    Seeker RichDenman's Avatar
    Join Date
    Dec 2011
    Posts
    7
    Articles
    0
    Excel Version
    2016

    Dates in Multiple Series



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi there,

    I am pretty good with excel from a calculations point of view and most other stuf I have been able to find from google but this has stumped me. I guess I cant find the right phrase to search on.

    I have PDR information for the team that I manage at work which consists of three colums of information for each individual A=Date of Review, B=Grade of Employee and C=Performance Rating. Each employee has there own tab with the historic PDR information.

    I want to create one chart that sumarises the performance of my whole team whereby I have a primary axis with a series for the grade at which employee is working and a secondary axis with a series for each employee's Performance Rating.

    The problem that I am having is that the review dates are not being matched up with the date that is used on the horizontal Axis. Each employee has their review on a different date and they all started the company at different times too...

    So my theory was I pick the dates from the longest serving employee and use that as the lavels for the horizontal axis. Lets say that the longest serving employee (person A) started in Janury 2001 and I use the method described above. The fist date on the horizontal axis is 01/01/2001. His development will plot fine. Person B started in June 2005 and had his first PDR then. So I would have expected the chart to line his first review score at June 2005 on the Horizontal Axis. What it actually does is plots it against 01/01/2001 because it identifies that this is the first number in the series.

    I am using a line graph in Excel 2007. I have also tried a scatter graph and that didnt seem to solve the problem either.

    Any help would be appreciated.

    Regards

    Rich

  2. #2
    Seeker RichDenman's Avatar
    Join Date
    Dec 2011
    Posts
    7
    Articles
    0
    Excel Version
    2016
    Apologies, I have just tried this again with scatter and it works perfectly. Sorry

  3. #3
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,294
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Quote Originally Posted by RichDenman View Post
    Apologies, I have just tried this again with scatter and it works perfectly. Sorry
    LOL! Not a worry, happens to all of us.
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Posting Permissions

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