The last step before creating the graph is to choose the data you want to graph.
![adding data for scatter chart in excel adding data for scatter chart in excel](https://i.stack.imgur.com/wtNQ7.png)
Finally, enter the information shown in rows 12 and 13.Enter the independent and dependent variable values into cells A4:B9.Your data will go in the first two columns in the spreadsheet.Label Column B as the Absorbance readings for each of the solutions in cell B3.Label Column A as the Concentration (M) of the known solutions in cell A3.Type what is seen in Figure 1a into the appropriate cells. Entering and Formatting the Data in Excel Next, a scatter plot is made of this empirical data.
#ADDING DATA FOR SCATTER CHART IN EXCEL SERIES#
First, a series of solutions of known concentration are tested for their absorption level. This fact can be used to calculate the concentration of unknown solutions, given their absorption readings. Creating a Scatter Plot of Titration Dataīeer's Law states that there is a linear relationship between concentration of a colored compound in solution and the light absorption of the solution.Entering and Formatting the Data in Excel.
![adding data for scatter chart in excel adding data for scatter chart in excel](https://img.pagecloud.com/a8HozOGZ__yZG4dLvMzDTs22agk=/1300x0/filters:no_upscale()/simplexct/BlogPic-vdc9c.jpg)
Untitled Document Basic Graphing in Excel-2007 Table of Contents