Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel chart help

  • 27-01-2016 4:42pm
    #1
    degsie
    Registered Users, Registered Users 2 Posts: 8,755 ✭✭✭


    I have a spreadsheet with four columns.
    Col 1 = Employee Name
    Col 2 = Start Date
    Col 3 = End Date (or blank if still employed)
    Col 4 = Dept (engineering/payroll/admin etc)

    I want to product a chart which shows the numbers of employees BY MONTH for the engineering dept only. So the x axis is Jan '14, Feb '14... to present and the y axis is the employee count.

    Can anybody help out? Totally stuck :(


Comments

  • #2
    degsie
    Registered Users, Registered Users 2 Posts: 8,755 ✭✭✭degsie


    steokeogh wrote: »
    What length of time are you looking to show 12 months or longer?

    From start of 2014 to present.


  • #3
    degsie
    Registered Users, Registered Users 2 Posts: 8,755 ✭✭✭degsie


    steokeogh wrote: »
    Will it be continually running or do you want it roll over every 24 months eg 01/2014 to 01/2016 or 05/2015 to 05/2016.

    Continually running for now. So if a new employee joins/leaves it will just update.


  • #4
    degsie
    Registered Users, Registered Users 2 Posts: 8,755 ✭✭✭degsie


    Thanks, should there be a definition in col E to check if employee role is engineering? The current computation shows if still employed only (I think). Really bad at this stuff, sorry.


  • #5
    fad460
    Registered Users, Registered Users 2 Posts: 24 ✭fad460


    Do you by any chance attach the excel sheet? I might help you.


  • #6
    degsie
    Registered Users, Registered Users 2 Posts: 8,755 ✭✭✭degsie


    fad460 wrote: »
    Do you by any chance attach the excel sheet? I might help you.

    Not sure if attachments are working but I've added it here. The second worksheet is what I worked out manually, this is the one I'd like to get automatically.


  • Advertisement
Advertisement