• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Chart with time of day in X Axis


Hello... I have what is hopefully a simple solution. I have a chart with a timeline for a work day. Starting at 5:00am until 3:00pm. I want the timeline to be evenly spread throughout the day but I cannot figure out how to make this happen. The times are all over the map. I want to show half hour increments across the X. (see attached screenshot)

chart - Copy.JPG


Excel Ninja
Isn't it show now as You've written ... with 0.25 major units?
If You would like to modify it ... test value which match with half hour ( results of 1/48 ).
With Your snapshot, it's a challenge to test or verify above.


Hi vletm... I seem to get close now after putting 0.02 in Major and 0.02 in Minor. Now I get 5:00 / 5:29 / 5:58 / 6:27 / 6:56 and so on. Not sure what I am missing for getting 5:00 / 5:30 / 6:00 / 6:30 etc