Open an Excel Workbook Page 2. Type your absorbance values into Column A 3. Type the (corresponding) concentration values into column B. 4. Click on the top left data box and drag to select all data, release mouse. 5. Click on the tab for Insert, and select Scatterplot. 6. Double click on a data point on the graph, then under Layout, select Trendline: linear. 7. Now in the Layout, under Trendline window, Select More Trendline Options and Select "Display Equation" and Display R-squared value. 8. In The Formatting Palate you can add a Graph (1) Title, (2) Y-axis label, and (3) X-axis label