Time scales for charts

I have a spreadsheet that contain peoples hours on a daily basis under separate headings and I want to create a separate std column chart for each person that contains dates as the x axis with hours as the y axis. I am using hh:mm format to add the hours because I need a total number of hours for each day, with a total number of hours for each month further down the spreadsheet. However, the time slot is not quite I'm looking for. What I would like to do is see the time scale axis with major unit displayed as a whole hour, eg 01:00 to 15:00 depending on how many hours are completed each day. Currenty it jumps from 00:00 to 01:12 and so forth.

I have attached a copy of what I currently have as the chart.

Any help on how to change the scaling axis would be much appreciated.

Many thanks!

Hi,

Use 0.0416666666666667 as your major unit in the Y axis. That is the decimal equivalent of 1 hour.