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
Bookmarks