Highlight cells D2 through D4 and then click on the "Insert" tab. Click "Line" in the Graph section you will see your Security Market Line. Stocks that are above the line constitute a good risk.

The ease with which you can create a line graph in Excel on your PC or Mac will do much to dispel the misconception that the program is arcane and unapproachable.. With just three clicks of a ...

Open Microsoft Excel. Enter you data down column A. Enter "=AVERAGE(A:A)" in cell B1. This configuration looks for all data points in column A so when you add data to the column, it is included in ...

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.

A scatter plot is just one style of chart-making in Excel. If you find that you need more flexibility in the presentation, you can right-click on the chart and select Change chart type .

Learn to calculate Consumer Price Index (CPI) using Excel and create its graph, please read through this article. We have discussed the prcedure extensively.