Need Help Creating Uniform Time Distrobution on Y-Axis

P

penroma

I am graphing call center times and I want the y-axis to have unifor
time distributions. Right now the points of time on the y-axis are 0
14:24, 28:48, 43:12, 57:36, 72:00 and 86:24. I would like for it be 0
10:00, 20:00, 30:00, 40:00, 50:00, 60:00. I have played around wit
the axis scale with no luck. Any suggestions would be appreciated
 
J

Jon Peltier

Enter your desired tick spacing as 10:00 in hh:mm format, and Excel will
convert that to the format it recognizes.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Time and Percentage Graph. 2
Showing 24 hour time along X-axis 0
Conditional Time Calculation 10
Axis formatting 0
Lines on x-axis 1
SUMPRODUCT where between 2 dates 3
How do I set my X axis to include equal increments of a day? 2

Top