X-axis in even one-hour increments

My chart type is x,y scatter.  The x-data is in the form of hh:mm:ss.  The x-axis is formatted in hh:mm:ss.  However, the values on the axis do not show up in 1-hr increments.  Instead, they are showing up as 00:00, 1:12, 2:24, 3:36, 4:48, 6:00, etc.  How do you get even 1-hr increments?

Thanks.

Answer
Answer

Ok, I found the problem.  Both the Major unit AND the Minor unit values must be fixed at 0.04166667.

That was really bugging me.

Thank you!!!

62 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated May 11, 2024 Views 33,065 Applies to: