A straight line will appear on the chart. In cell A2 type -10. There are three basic types of graph that you can create in Excel each of which works best for certain types of data.
Select the Layout tab from Chart Tools.
Highlight the concentration and absorbance columns and click on Insert on the top menu and click on Chart on the drop down menu. Now lets use Microsoft Excel to evaluate and graph this function. 1 Click on the xy scatter option and click Finish. Graph equations in excel are easy to plot and this tutorial will walk all levels of excel users through the process of showing line equation and adding it to a graph.