Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    195
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Workload Graph (2003)

    I have imported a list of task from Outlook to Excel. The tasks have the following fields: description, start date, due date, number of hours of work fro the task. I would like to generate a graph that shows the number of work hours per day (see the file attached).

    Thanks for your help,

    Marcel

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Workload Graph (2003)

    I am not clear what you are after?

    Could you elaborate what you are trying to plot? Are you trying to plot the sum of the hours vs each start date?

    It would help if your "dates" were actually dates rather than text.

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    195
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Workload Graph (2003)

    I try to calculate the number of work hours per day. Let say one task is between today Tuesday 1st of June and next Tuesday, this task requests 6 hours of work. That means we have 6 opened days between the start date and the due date for this task. We will need to work 1 hour per day to complete the task before the dead line. The idea is to take all the tasks in the list and be able to plot the number of work hours per day in order to see how many percent of the day has to be considerated as busy.
    I have attached the same Excel file with real dates.

    Marcel

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Workload Graph (2003)

    Does the attached zipped workbook do what you want? It requires the Analysis Toolpak add-in to be installed, for it uses the WEEKDAY and NETWORKDAYS functions. If you use a non-English version of Excel, these functions are probably not translated.

  5. #5
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    195
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Workload Graph (2003)

    Hans,

    Perfect, thank you very much for your help.

    Marcel

Posting Permissions

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