2 X Axis on the same Y Axis??

[Mark McInerney]

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.

 

[AlphaFrog]

Excel has a Secondary x axis feature or alternatively a secondary Y axis

 

[Mark McInerney]

Hi Alphafrog......Sorted. Many Thanks - just what I was looking for!