Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to change y axis automatic time range?
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???? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to change y axis automatic time range?
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" wrote in message ... 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???? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo Box input range automatic update | Excel Discussion (Misc queries) | |||
time sheet drop down lists | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Time Stamp without change | Excel Discussion (Misc queries) | |||
Time Stamp-With Change | Excel Discussion (Misc queries) |