Hi guys I am new to the forum,
Not sure if the title makes any sense but here is what I am trying to do.
I am basically generating a schedule to show how many workers I would need for all of on going projects at a given date(during 3~4 week duration). I have generated a horizontal bar chart with project start and end date and have number of workers labeled on the right side.
Is there a way to show how many workers are needed on each given day on a chart? It would be like taking the sum of vertical values from a horizontal chart. I am having trouble because the projects have different range of dates therefore the number of workers needed will have to total between various start date >= <=end date.
It doesn't necessarily have to be a bar chart, it could be a linear chart reflecting range and count. As long as I can see the count for each day for the next few weeks. I also tried to create a pivot using sumifs with date range but the number generated is not what I was looking for.
Not sure if how I explained makes sense.
Ex.
8/25 would show FTE = 8
8/26 - 8/27 FTE = 16
8/28 -09/09 FTE = 21
09/10 - 09/11 FTE = 16
09/12 - 09/15 FTE = 13
09/16 - 10/14 FTE = 8
and so on....
This is confusing to explain.
Please refer to the orange bar chart
Thanks for the help!!!
Bookmarks