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????

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"mike" <(E-Mail Removed)> wrote in message
news:7A32A105-CFA0-4048-B42A-(E-Mail Removed)...
>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????