VirtualInsanity
New Member
- Joined
- May 23, 2012
- Messages
- 23
- Office Version
- 365
- Platform
- Windows
Hi there,
I've been going round in circles trying to figure this one out. I have to show on a graph staff on leave during a certain period, including how many per team. I'm looking for a graph with staff names on the vertical axis and each date on the horizontal axis then a plot mark showing who is away on which date, with a bar graph overlayed showing how many people from each team are away on each date. I'm not sure how to present the data on a table so the graph will work but I thought something like this might work (where the team name indicates that person is away on that date). Any help appreciated!
[TABLE="width: 563"]
<colgroup><col><col span="2"><col><col><col></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]John[/TD]
[TD]Mark[/TD]
[TD]Susan[/TD]
[TD]Ronald[/TD]
[TD]Andrea[/TD]
[/TR]
[TR]
[TD="align: right"]23/12/2017[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]24/12/2017[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]25/12/2017[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]26/12/2017[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]27/12/2017[/TD]
[TD]Customer Service[/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]28/12/2017[/TD]
[TD]Customer Service[/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]29/12/2017[/TD]
[TD]Customer Service[/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]30/12/2017[/TD]
[TD]Customer Service[/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]31/12/2017[/TD]
[TD]Customer Service[/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]1/01/2018[/TD]
[TD]Customer Service[/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]2/01/2018[/TD]
[TD]Customer Service[/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]3/01/2018[/TD]
[TD]Customer Service[/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]4/01/2018[/TD]
[TD]Customer Service[/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]5/01/2018[/TD]
[TD]Customer Service[/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]6/01/2018[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]7/01/2018[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]8/01/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]9/01/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]10/01/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]11/01/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Accounts[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]12/01/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Accounts[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]13/01/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]14/01/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]15/01/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
I've been going round in circles trying to figure this one out. I have to show on a graph staff on leave during a certain period, including how many per team. I'm looking for a graph with staff names on the vertical axis and each date on the horizontal axis then a plot mark showing who is away on which date, with a bar graph overlayed showing how many people from each team are away on each date. I'm not sure how to present the data on a table so the graph will work but I thought something like this might work (where the team name indicates that person is away on that date). Any help appreciated!
[TABLE="width: 563"]
<colgroup><col><col span="2"><col><col><col></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]John[/TD]
[TD]Mark[/TD]
[TD]Susan[/TD]
[TD]Ronald[/TD]
[TD]Andrea[/TD]
[/TR]
[TR]
[TD="align: right"]23/12/2017[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]24/12/2017[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]25/12/2017[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]26/12/2017[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]27/12/2017[/TD]
[TD]Customer Service[/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]28/12/2017[/TD]
[TD]Customer Service[/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]29/12/2017[/TD]
[TD]Customer Service[/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]30/12/2017[/TD]
[TD]Customer Service[/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]31/12/2017[/TD]
[TD]Customer Service[/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]1/01/2018[/TD]
[TD]Customer Service[/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]2/01/2018[/TD]
[TD]Customer Service[/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]3/01/2018[/TD]
[TD]Customer Service[/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]4/01/2018[/TD]
[TD]Customer Service[/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]5/01/2018[/TD]
[TD]Customer Service[/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]6/01/2018[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]7/01/2018[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD]Customer Service[/TD]
[/TR]
[TR]
[TD="align: right"]8/01/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]9/01/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]10/01/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]11/01/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Accounts[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]12/01/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Accounts[/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]13/01/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]14/01/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]15/01/2018[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Accounts[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]