Beginner23
New Member
- Joined
- Apr 21, 2020
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Dear all,
I need your help! I have the follwoing table below (there are more but collums but for simplicity to explain I only show these).
I would like to ceate a pivot table, connect a timeline to the pivot and plot the actions in a stable diagram showing when the actions went in and when the action went out (show 1 on the y-axel when active).
I have manage to create the pivot table and connect a timeline to the table, but how do I mange to plot te actions in stable diagram (that will change dependent on the timeline)?
Please help!
/B
I need your help! I have the follwoing table below (there are more but collums but for simplicity to explain I only show these).
I would like to ceate a pivot table, connect a timeline to the pivot and plot the actions in a stable diagram showing when the actions went in and when the action went out (show 1 on the y-axel when active).
I have manage to create the pivot table and connect a timeline to the table, but how do I mange to plot te actions in stable diagram (that will change dependent on the timeline)?
Please help!
/B
Date | Action In | Action Out |
2020-04-21 | 08:02:34 | 08:03:34 |
2020-04-21 | 08:08:34 | 08:10:34 |
2020-04-22 | 07:02:34 | 07:34:34 |
2020-04-22 | 09:08:34 | 09:34:34 |