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