Mark McInerney
Active Member
- Joined
- Apr 4, 2012
- Messages
- 281
- Office Version
- 365
- Platform
- Windows
I am trying to graph 2 very different sets of data (X Axis) onto the same timeline (Y Axis).
My X axis are as follows:
X Axis A = Number of staff on the shop floor at any point in time during the opening hour of the store e.g. 09:00 thru to 18:00
X Axis B = The amount of sales the shop has at any point in time during the opening hour of the store e.g. 09:00 thru to 18:00
Y Axis = The opening hours of the store i.e. 09:00, 10:00, 11:00, 12:00 etc thru to 18:00
The business case behind my request is that I am trying to create a visual that will help me identify if I have the correct amount of staff on the floor for the different hours of the day.
Is this possible?
Appreciate any thoughts / help / support / counselling / therapy......It is driving me crazy!
Thanks.
My X axis are as follows:
X Axis A = Number of staff on the shop floor at any point in time during the opening hour of the store e.g. 09:00 thru to 18:00
X Axis B = The amount of sales the shop has at any point in time during the opening hour of the store e.g. 09:00 thru to 18:00
Y Axis = The opening hours of the store i.e. 09:00, 10:00, 11:00, 12:00 etc thru to 18:00
The business case behind my request is that I am trying to create a visual that will help me identify if I have the correct amount of staff on the floor for the different hours of the day.
Is this possible?
Appreciate any thoughts / help / support / counselling / therapy......It is driving me crazy!
Thanks.