How to Chart 24 Hours on a Vertical Axis in Excel. ... Rather than chart all traffic using multiple data series, you can note only the peak times and chart these times on a graph's vertical axis.

Check you have labelled each axis correctly, and give your line graph a title. Examples. ... Between each multiple of 10 is ten subdivisions. Each subdivision is worth 1°C.

If you use a line chart with two columns of data, each column will represent the Y axis of a separate line. More For You How to Change Columns Into Rows in Excel 2007 ...