To make a line graph there needs to be an X-axis, which is horizontal, and a Y-axis, which is vertical. The two axis represent different sets of data so the data is required too. The easiest way to make a line graph is using a spreadsheet like Excel.
Creating the chart requires only a couple of steps.
- Get the data The starting point is to have two sets of data. Often this means a variable which changes in time. This should be inputted into the spreadsheet in two columns. For example, the time data in column A and the corresponding variable data in column B. The time data will be put on the X-axis of the graph, and the variable data on the Y-axis.
- Create a chart In Excel, click on the Inserts tab then Charts and then click Line. This will insert the chart into the spreadsheet based on the information in the columns, including the headers.
- Format It is possible to change the format of the chart by clicking on chart. The style of line plotting the variables can be changed as can the chart title, X-axis title, and Y-axis title. It is also possible to include a legend and change the font size, color and type.