• 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.

X AXIS h:mm sorting

G

GB

Member
Hi,

I'm using version 2010 and creating a chart with my X axis as h:mm and my Y axis as percentage values. The problem is that my x axis data starts at 11:00 and finishes at 02:30 the following day. I am aware that the natural numbers are less (as there is no underlying date component and I don't want one either) for time from 0:00 to 2:30 than from 11:00 to 23:59. I want to present the data from left to right starting at 11:00 and ending at 02:30. I tried to format the X axis on the chart but found nothing that worked, but I'm sure there is a way. Can you help please.


thanks

Birko
 
GB


Set your Min and Max values of the X-Axis to appropriate values

like 0 and 2, for midnight and midnight 2 days later

Then set the X-Axis number format to [H]:MM
 
Thanks again Hui, I had to rebuild my date component back into the h:mm part of the time to get the data to plot correctly, then set the min/max as you suggested. You are always very to respond and I really appreciate it.

Thanks

Birko
 
You must log in or register to reply here.
Back
Top