How to Chart 24 Hours on a Vertical Axis in Excel. ... Click the second entry in the Type box, which corresponds with 24-hour time. Click "OK." Advertisement. Article continues below this ad.