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???? |
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???? |
All times are GMT +1. The time now is 03:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com