Spreadsheet #13:  Plotting Two Sets of x,y-Data on the Same Chart

[Back to Group 1 Assignments] [Back to Chem3020 home]

Consider the following data from an experiment in which the change in absorbance at two different wavelengths is monitored for a single chemical reaction.  Plot the two sets of x,-y data pairs on the same chart, one at 450 nm and the other at 600 nm.  Fit each line with a linear least-squares fit and plot the best-fit-line through for both wavelengths.  Hint:  (Click to download the data set: 13-dubxy.)

Time	Abs @	Regression
(min)	450nm	Constants
0	0.010		<-Slope
3	0.178		<-Intercept
6	0.346		<-R^2
9	0.514
12	0.682
15	0.850
18	1.018
21	1.186
Time	Abs @	Regression
(min)	600nm	Constants
0	0.030		<-Slope
2	0.094		<-Intercept
4	0.158		<-R^2
7	0.254
10	0.350
14	0.478
17	0.574
20	0.670

Excel Programming Tips:

To add another set of points to a graph, select the source data window and then the series tab. Click on Add to add another series. To the right of the series box, you can define the new range of the X and Y Values.

Assign trendlines separately to each data series after the chart is created.