Set time max/min on Chart

[Raggy]

I am charting logon times and have created a graph to show this but I really want it to show the Y axis a starting at 7am and then showing 15min intervals to 10:15 but cant seem to figure it out how to do it. Any help appreciated.

 

[vmjan02]

Hi,

Just select Y Axes Option,
In Minimum option put your starting time ie 7
In Units for Major put as 0.15

the attached screen will help you. I am not sure as which version of excel you are using.

 

[Raggy]

Hi,

Just select Y Axes Option,
In Minimum option put your starting time ie 7
In Units for Major put as 0.15

the attached screen will help you. I am not sure as which version of excel you are using.

I am using Office 365 and tried those settings but mine then does this:

 

[Raggy]

Thanks for the reply, managed to do it by setting better values by finding out the value of the times I wanted and using that

 

[vmjan02]

Great it helped, thanks for the feed back