• 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

    Hui...

  • 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

Nu2Java

Member
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
 

vletm

Excel Ninja
Nu2Java
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.
 

Nu2Java

Member
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
 
Top