Line charts are appropriate in Excel if you have text labels, dates, or a few numeric labels on the horizontal axis (x-axis). These are the steps to create a line graph in Excel.

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.

How to Add a Second Y-Axis on Excel & Make a Second Series at the End of the Chart. Microsoft Excel charts give you a large number of options for displaying the data in your spreadsheet.

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

Learn how to draw and understand information presented by a line graph with this interactive guide by BBC Bitesize for KS2 pupils. ... The vertical axis is a line which goes up and down.