This preview shows pages 1–4. Sign up to view the full content.
Graphing with Excel 1
1
Table of Contents
1.
Graphing Data
1.1.
Starting the Chart Wizard
1.2.
Selecting the Data
1.3.
Selecting the Chart Options
1.3.1. Titles Tab
1.3.2. Axes Tab
1.3.3. Gridlines Tab
1.3.4. Legends Tab
1.3.5.
Data Labels Tab
1.4.
Selecting the Chart Location
1.5.
Changing an Existing Graph
1.6.
Changing the Look of the Graph
1.6.1. Editing Titles
1.6.2.
Formatting Axes
1.6.3.
Changing Data Markers
2.
Graphing Multiple Data Series
3.
Fitting a Curve to a Data Series
4.
Adding Error Bars to a Data Series
5.
Estimating Uncertainty in Slope of a Linear Trendline
5.1.
Drawing the Line
5.2.
Rotating the Line
5.3.
Estimating the Slope of the Line
6.
Glossary of Excel Terms
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document Graphing with Excel 2
2
1.
Graphing Data
1.1.
Starting the Chart Wizard
When the data
worksheet
has been set up (the data entered and the columns labeled), it is time to graph
the data.
Before starting a graph, it is important to have a clear idea of what values go on what axis.
Usually, the independent variable goes on the xaxis and the dependent variable goes on the yaxis.
For example, consider a data series that measured the distance from the motion detector to a glider
which moved along a track.
To know the distance to the glider, one must pick a particular time.
The
distance depends on the time.
The independent variable is time and the dependent variable is distance.
Therefore, the distance versus time graph of that data would have the time on the xaxis and the distance
on the yaxis.
To create a graph, click the
Chart
Wizard
button in the area
beneath the top menu bar or go to
the top menu bar, click
Insert
and
select
Chart
.
The
Chart Wizard
will go through the different steps of
making a graph.
In the window that
pops up, the
Chart Type
window,
choose the
XY (Scatter)
type from
the list of standard graph types. In
the
Chart subtype
area make sure
the highlighted image is the one
without any lines or curves, as
shown in
Figure 1
.
Click the
Next
button when done.
Figure 1: Chart Wizard with the Chart Type window showing
the Standard Types tab with all the possible types of graphs.
The XY (Scatter) graph is selected.
Graphing with Excel 3
3
1.2
Selecting the Data
In the window that pops up click the
Series
tab.
Here is where the data will
be assigned to the x and yaxes.
If
there are any data series already
entered, click on each one in the
Series
area and then click the
Remove
button
until there are none left.
Click the
Add
button to begin a new data series.
There are three fields on the righthand
side of the widow:
Name
field,
X
Values
field, and
Y Values
field.
Click the
Data Range
box
next to
the
X Values
field.
The
Source Data
window will
collapse to a small window only
showing the
X Values
field, as shown
in
Figure 3
.
Go to the
worksheet
with
the data and select the data for the x
axis.
A dashed box around the cells
indicates what has been selected.
If a
mistake is made in selecting data, click
in the field in the shrunken
Source
Data
window and delete the range
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
This is the end of the preview. Sign up
to
access the rest of the document.
This note was uploaded on 12/14/2009 for the course PHYS PHYS102 taught by Professor Kikkawa during the Spring '09 term at UPenn.
 Spring '09
 Kikkawa
 Physics

Click to edit the document details