How to Make a Calibration Curve Graph in Excel 2007

A calibration curve is used in analytical chemistry to figure out the concentration of a substance in a sample, by comparing the sample to a set of predetermined data. In order to build a calibration curve in Excel 2007, you should already have your experimental data formatted in a worksheet with columns (x, y) and column headers. For example, if you want to plot absorbance vs. concentration, put your absorbance values in column A and your concentration values in column B.

...
Calibration curves help you determine concentrations in a sample

Step

Highlight both columns of your data. Left-click on the top left of your data, then drag the mouse to the bottom-right of your data.

Step

Click the "Insert" ribbon.

Step

Click the "Scatter" button in the Charts section of the Insert ribbon. Click the bottom-right icon in the Scatter Plot drop-down list. The icon has squares with lines between them. The ribbon has now automatically switched to “Design,” and your plot has appeared on screen.

Step

Click “Select Data,” in the Data section of the Design ribbon.

Step

Click the list item titled “Series1,” then click "Edit" right above that.

Step

Type “Calibration Curve” in the “Series Name” text box. Press "OK."

Step

Press "OK" again, and you are back on your spreadsheet with the Calibration Curve plot.