#EXCEL 2007 TUTORIAL GRAPHS SERIES#

Your data should look as though it falls along a linear path.

The initial scatter plot is now finished and should appear on the same spreadsheet page (called a sheet) as your original data.

Keep the chart as object in Sheet 1 (the current sheet). Click off the Show Legend option (Figure 4d).Enter Concentration (M) for the Value X Axis.(Instead select Chart>Layouts to add titles and legends to the graph). The next dialogue in the wizard is where you label your chart (Figure 4c).

#EXCEL 2007 TUTORIAL GRAPHS SERIES#

The Series option should be set to Columns, which is how your data is organized (see Figure 4b). The Data Range box should reflect the data you highlighted in the spreadsheet.

Choose XY (Scatter) and the unconnected points icon for the Chart sub-type (Figure 4a).

The first dialogue of the wizard comes up (In Excel-2007 choose Insert>Scatter Chart - selecting the unconnected points chart). If the Chart Wizard is not visible, you can also choose Insert > Chart.

Choose the Chart Wizard icon from the tool bar (see Figure 3 for two examples).

With the data you want graphed highlighted, start the chart wizard 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 Format > Cells.The concentration data is probably better expressed in scientific notation. Your data will go in the first two columns in the spreadsheet. Repeat for the absorbance data column (B5 through B10 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), (use Home>Number in Excel-2007). Click and drag over the range of cells that will hold the concentration data (A5 through A10 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.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 in the appropriate cells. Entering and Formatting the Data in Excel Next, a scatter plot is made of this empirical data. 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.

Untitled Document Basic Graphing in Excel-2003 Table of Contents

Excel 2007 tutorial graphs