AsherPSmear
New Member
- Joined
- Sep 27, 2020
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
Good morning!
Not sure if you smelt the smoke but my brain is fried! Would you mind looking into the below?
I'm trying to build a pivot chart that shows capacity vs utilization on each day.
Mac
Not sure if you smelt the smoke but my brain is fried! Would you mind looking into the below?
I'm trying to build a pivot chart that shows capacity vs utilization on each day.
Location | Max Capacity | # Personnel | Departure | Rental Start | Rental Complete |
---|---|---|---|---|---|
Site A | 3 | 2 | 6 Jan 21 | 20 Dec 20 | 10 Jan 21 |
Site B | 2 | 1 | 18 Jan 21 | 1 Jan 21 | 22 Jan 21 |
Site A | 3 | 1 | 8 Jan 21 | 22 Dec 20 | 12 Jan 21 |
- X-axis is dates (20 Dec - 22 Jan 21)
- Y-axis is # personnel
- Horizontal line is max capacity
Mac