In order to draw the line graph we require several pairs of coordinates. These coordinates represent the relationship given in the equation. For example, for y = 3x , the y value is always equal ...

How to create a Line Chart in Excel. To create a line chart in Excel, the procedure is as follows: Select the data across both the columns (from A3 to B12).

The bottom part is a graph of the equation, which, as you can see, is exactly the same. To be fair, this equation cheats a little bit. You may notice that the y-axis of that graph begins at ‘k’.

To make a smooth curved line graph in Excel, follow these steps-Enter your data in the spreadsheet and select it to make a graph. Go to the Insert tab and insert a 2-D line graph.

Capture relationships between data sets by graphing linear equations in Microsoft Excel 2007. Linear equations allow you to predict values within your data set and view the overall trend.