ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Showing 24 hour time along X-axis (https://www.excelbanter.com/new-users-excel/447262-showing-24-hour-time-along-x-axis.html)

student_grapher

Showing 24 hour time along X-axis
 
Hi there,

I would like to graph sleep times over a period of 2 weeks in a stacked bar graph. Each bar will represent time fallen asleep and woken up, with the length of the bar showing the duration of the night's sleep. I would like the X-axis to display clock times in 24-hour time (i.e. starting at 0:00, 0:30, 1:00, 1:30 all the way to 23:30). Can anyone help in making the X-axis display in this way?

Thanks


All times are GMT +1. The time now is 02:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com