How to Plot a Standard Curve in Excel

Plot a standard curve using Microsoft Excel and its Scatter Chart capabilities.

Video of the Day

Open Microsoft Excel

Data pairs entered into adjacent columns on an Excel worksheet.
credit: Ron Price

After starting Excel, enter your data pairs in adjacent columns and rows on a new worksheet.

Use the Scatter with Straight Lines and Markers chart for a Standard Curve.
credit: Ron Price

Select the data values with your mouse. On the Insert tab, click on the Scatter icon and select Scatter with Straight Lines and Markers from its drop-down menu to generate the standard curve.

An example of a standard curve.
credit: Ron Price

Adding a trendline can predict other values, when one of the data pair is unknown.

A completed standard curve graph with trendline.
credit: Ron Price

To add a trendline to the graph, right-click on the standard curve line in the chart to display a pop-up menu of plot-related actions. Choose Add Trendline from this menu.

Show Comments