LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 29th 12, 11:24 AM
Junior Member
First recorded activity by ExcelBanter: Sep 2012
Posts: 1
Default 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?


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Start Time to End Time... Minutes On Each Hour... How to distribute proportionately? SVCitian Excel Programming 0 September 15th 10 04:58 PM
Changing an axis to show time with hour intervals hollis78 Charts and Charting in Excel 3 October 8th 08 06:28 PM
"h:mm" format, but 12-hour time, not 24-hour time? [email protected] Excel Discussion (Misc queries) 5 September 2nd 08 10:54 AM
how to calculate time start & time finish in quarter hour Peter Wu Excel Discussion (Misc queries) 3 June 7th 06 12:58 AM
Extract the hour from a cell showing the date and time Paul Sexton Excel Worksheet Functions 2 February 27th 06 07:15 PM

All times are GMT +1. The time now is 11:44 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017