Mac excel graphing format axis number for an hour

broken image
broken image

There are several ways you can approach this issue, depending on the type of chart you want to create. He is wondering if there is a way of plotting the times on the chart, as well as the date. Richard has some source data that shows the date and time displayed in the format dd/mm/yy hh:mm, but when he creates a chart from that data, the only thing that is plotted is the date.