How to change y axis automatic time range?

G

Guest

I am charting end times for my batch stream.
Sometime it finishes at 11pm sometimes at 3am and everywhere in between.
When i create the chart it choose the y-axis time ranges for me.
Starting range is 12am to 5am the next day.

I would like to change the y-axis range from 10pm to 10am next day.
How can i do that????
 
J

Jon Peltier

Is the problem that the time increases up to midnight then starts over at
zero? Quick and Dirty: add 1 to times after midnight. More rigorous: enter
the date and time for each cell.

- 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

Time on Y-Axis 3
y-axis auto scaling... 2
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS 4
Trying to change x-axis date range 5
Hide Graph of Data Outside X-Axis Range 2
How to set scale of y axis for time 4
x y scatter chart series ranges reset to x(range) = y(range) 4
Plotting Date and Time on the same chart axis 1

Top