+ Reply to Thread
Results 1 to 7 of 7

Project resource profile chart

  1. #1
    Registered User
    Join Date
    04-28-2022
    Location
    Kenilworth, England
    MS-Off Ver
    Office 365
    Posts
    2

    Project resource profile chart

    hi all,

    i am trying to create a simple resource plan profile/curve for my project which spans 19 months. the source data is a simple table with following columns:

    resource name
    start date
    end date
    total days
    allocation rate (%)

    i would like to create a line or bar chart where there would be months on the x-axis and total count of resources (or a stack) on y-axis taking into consideration allocation rate, e.g. for june '22, i will have 2 people full time and 2 people 3 days/week (60% allocation) = 3.2 people for that month.

    is there a way of doing this in excel?

    many thanks.

    mark

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,408

    Re: Project resource profile chart

    Welcome to the forum.

    Probably!

    There are instructions at the top of the page explaining how to attach your sample workbook.

    A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    04-28-2022
    Location
    Kenilworth, England
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Project resource profile chart

    thanks, ali. now with an attachment.
    Attached Files Attached Files

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,408

    Re: Project resource profile chart

    YOu haven't shown us what the chart would look like for the sample data. A handdrawn mock-up will suffice.

  5. #5
    Valued Forum Contributor
    Join Date
    10-14-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2019
    Posts
    353

    Re: Project resource profile chart

    @mark,
    When you google on "excel project planning resource histogram chart", you will get many hits with good examples........
    Kind regards,
    Piet Bom

  6. #6
    Forum Contributor
    Join Date
    01-17-2012
    Location
    Canada
    MS-Off Ver
    Excel 365
    Posts
    221

    Re: Project resource profile chart

    Hi Mark,

    Does this work for you?
    Attached Files Attached Files

  7. #7
    Valued Forum Contributor
    Join Date
    10-14-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2019
    Posts
    353

    Re: Project resource profile chart

    Found this template in my archive.....
    The data table on the left can grow downward and the timescale can grow to the right.
    The formulas can be used for timescale units: days, weeks, months, quarters or years.
    The chart is on the top right and remains visible when you freeze panes just under the bottom of the chart.
    see attachment.......
    Attached Files Attached Files

+ 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. Project Program Cost Profile
    By maclarkson in forum Excel General
    Replies: 7
    Last Post: 10-02-2019, 09:32 PM
  2. Resource allocation Per Project
    By excelhelpexcel in forum Excel General
    Replies: 0
    Last Post: 04-07-2014, 05:14 PM
  3. Convert Resource Profile from Days to Weeks
    By Flyinace2000 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-03-2012, 12:27 PM
  4. [SOLVED] Production Planning / Resource Profile
    By ExcelStefan in forum Excel General
    Replies: 0
    Last Post: 07-25-2012, 03:09 AM
  5. Project Resource Assignment Tracking
    By sanlen in forum Excel General
    Replies: 0
    Last Post: 01-18-2011, 12:20 AM
  6. Replies: 1
    Last Post: 10-18-2005, 11:05 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