How to make standard curve?
1 Input your data in excel
2 select all the data and insert the Scatter charts
3 Double-click one of the points in the chart, it will show some options
4 Click Add Chart Element-Trendline- Linear
5 Click Display Equation on chart, and display R-squared value on chart
6 In this graph, x-axis is concentration, y- axis is absorbance. Use the equation to calculate your unknow samples’ concentration, which is you know y and solve x.