In this case, it is the titration of a strong acid with a strong base (see Figure 10 for the final plot). In this next part of the tutorial, we will work with another set of data. Return to Top Creating an Initial Scatter Plot of Titration Data
Go to the tutorial on creating regression lines to find out how to use a regression line with this scatter plot to calculate the concentrations of the two unknowns.
Grabbing one of the four corner handles allows you to resize the graph. With your graph highlighted, you can click and drag the chart to a wherever you would like it located on the spreadsheet page.
Click on the Title to edit &/or format the entry.Select Chart Tools>Chart Title option to change attributes of the title.Select the Chart, then Chart Tools>Layouts Menu: The next step adds titles to the X- and Y-Axes. The X-Axis should have concentration data, and the Y-Axis should have the absorbance data. The basic XY-Chart should appear on your worksheet. The type of chart you want is a XY-Scatter Chart using only markers (see Figure 3).With the data you want graphed highlighted, in this case A3:B9, insert a chart from the Insert>Chart menu Return to Top Creating the Initial Scatter Plot Highlight the data in both the concentration and absorbance columns (but not the unknown data or the labels for each column).The last step before creating the graph is to choose the data you want to graph. Choose the Scientific Category and set the Decimal places to 2.Highlight the concentration data and choose Home>Number.The concentration data is probably better expressed in scientific notation. Repeat for the absorbance data column (B4 through B9 for the sample data), setting the decimal places to 4.Under Category choose Number and set Decimal places to 5.from the Format menu at the top of the Excel window), Click and drag over the range of cells that will hold the concentration data (A4 through A9 for the sample data).These are absorbance values from two samples of unknown concentrations (more on this later). 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.
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.
Entering and Formatting the Data in Excel.Untitled Document Basic Graphing in Excel-2007 Table of Contents