Excel change horizontal axis in stacked bar graph

[erin00]

I have a table and a bar graph with dates and duration of each activity the graph looks good but the time label on horizontal line is wrong. how do i change this?

I attached what the graph looks like. I want it to be one hour interval (3:00 AM 4:00 AM 5:00 AM ...)

My data table only contain dates for the vertical axis and time durations for the bar on the graph.

Any advise?

 

[pgc01]

Hi

Set the axis major unit to 1 hour