Microsoft PowerPoint - Excel Tutorial #4-Graphing multiple data sets

Short Description
click the “series”. tab and type in. the new label. names. # 4- Page 1 of 3. Graphing using Microsoft Excel. Tutorial #4- Graphing multiple data sets …

Website: www.eiu.edu | Filesize: 107kb

Content
1. Enter data into an Excel spreadsheet as shown below.
For this demonstration, let’s assume that you measured the absorbance (A450) of
an enzyme-catalyzed reaction with variable enzyme concentration. Your data
might look like this-
2. To graph this data,
I highlighted the
area shown in blue,
selected Chart
Wizard, then
selected the “XY
scatter” graph in
step 1 and “rows”
in step 2.
Note- If you
wish to change
the titles of each
line, simply
click the “series”
tab and type in
the new label
names.
# 4- Page 1 of 3
Graphing using Microsoft Excel
Tutorial #4- Graphing multiple data sets3. After completing steps 3 and 4 of Chart Wizard, my graph looks like this:
4. Now, simply right click on any data point and select
“add trendline”. You must repeat this for each set of data
points. The results are shown on the next slide.
Graphing multiple data sets (cont.)
# 4- Page 2 of 3…