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 ...

By selecting all three columns of data, you can select the type of chart from Excel's Insert tab. The most useful selection is a bar chart, because it allows you to format the second series as a line.

If you have uneven distribution of data in your Excel chart, here is a better way to change the automatic axis settings. ... If an Excel chart’s vertical axis is incremented by 20,000, ...