How to Make a Calibration Curve Graph in Excel 2007

1. 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.
2. Click the 'Insert' ribbon.
3. 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.
4. Click “Select Data,” in the Data section of the Design ribbon.
5. Click the list item titled “Series1,” then click 'Edit' right above that.
6. Type “Calibration Curve” in the “Series Name” text box. Press 'OK.'
7. Press 'OK' again, and you are back on your spreadsheet with the Calibration Curve plot.