How to Chart 24 Hours on a Vertical Axis in Excel. Graphs in Microsoft Excel typically chart time on the horizontal axis. Time is the independent variable in most relationships and dependent ...