Get documents about "Bar Graph Line Graph
Document Sample
8th Grade Displaying Science Fair Results in a Graph
Which to use?
Bar Graph Line Graph
4
8
3
You can use a bar graph You can use a line graph
6
to display and compare 2 to show how data change
4
data in separate 1 over a period of time.
2 categories.
0
0
0 1 2 3 4 5
A B C D E
Example:
Wrong Graph to Choose:
Right Graph to Choose:
☺
Brand of Ounces
paper of Water Paper Towel Absorbency Paper Towel Absorbency
Towels Absorbed
7.0 7.0
Bounty 6.0
Scots 4.0 6.0 6.0
Brawny 5.5
Ounces of Water
Ounces of Water
5.0 5.0
Viva 3.0
Sparkle 2.0 4.0 4.0
3.0 3.0
2.0 2.0
1.0 1.0
0.0 0.0
Bounty Scots Brawny Viva Sparkle Bounty Scots Brawny Viva Sparkle
Brands of Paper Towels Brands of Paper Towels
Example:
Wrong Graph to Choose: Right Graph to Choose:
☺
Time Height Growth of Pepper Plant
(days) (inches)
4 Growth of Pepper Plant
0 0
4
Height (inches)
1 0.7 3
Height (inches)
2 1.2 3
2
3 2.5 2
4 2.9 1
1
5 3.4
0
0
1 2 3 4 5
0 1 2 3 4 5
Time (days)
Time (days)
ERNoël, 12‐1‐09
Instructions for Creating a BAR Graph using EXCEL 2007
1) Open an Excel spreadsheet
2) Enter your data into
a. Column A goes to the horizontal axis (X‐axis – Independent V.)
b. Column B (and C if you have a double bar graph) goes to the vertical axis
(Y‐axis – Dependent V.)
3) Choose your graph
a. Highlight all your data in all columns
b. Click on the “Insert” tab
c. Click on “Column” in the Charts menu
d. From the drop down menu choose
which kind of bar graph you want
Complete your graph with appropriate labels, etc.
4) Title
a. Click on the outer edge of the graph
(edge becomes light blue double line as shown)
b. Click on “Layout” tab
c. Click on “Chart Title” in the Labels menu
d. From the drop down menu choose where you want your title
e. Type in your title in the box which pops into place
ERNoël, 12‐1‐09
5) Label the axes
a. Click on the outer edge of the graph
(so edge becomes light blue double line)
b. Click on “Layout” tab
c. Click on “Axes Titles” in the Labels menu
d. Put the cursor on “Primary Horizontal Axis Title”
e. Make your choice from the drop down menu
f. Type your label for the horizontal axis in the box
Repeat the steps for the vertical axis
a. Click on the outer edge of the graph
(so edge becomes light blue double line)
b. Click on “Layout” tab
c. Click on “Axes Titles” in the Labels menu
d. Put the cursor on “Primary Vertical Axis Title”
e. Make your choice from the drop down menu
f. Type your label for the vertical axis in the box
6) Save the EXCEL file! You can copy and paste this graph into a word document.
Paper Towel Absorbency
7.0
6.0
Ounces of Liquid
5.0
4.0
3.0 water
2.0
oil
1.0
0.0
Bounty Scots Brawny Viva Sparkle
Brands of Paper Towels
ERNoël, 12‐1‐09
Instructions for Creating a LINE Graph using EXCEL 2007
1) Open an Excel spreadsheet
2) Enter your data into
a. Column A goes to the horizontal axis (X‐axis – Independent V.)
b. Column B (and C if you have a double line graph) goes to the vertical axis
(Y‐axis – Dependent V.)
3) Choose your graph
a. Highlight all your data in all columns
b. Click on the “Insert” tab
c. Click on “Scatter” in the Charts menu
d. From the drop down menu choose
which kind of trend line you want
Complete your graph with appropriate labels, etc.
4) Title
a. Click on the outer edge of the graph
(edge becomes light blue double line as shown)
b. Click on “Layout” tab
c. Click on “Chart Title” in the Labels menu
d. From the drop down menu choose where you want your title
e. Type in your title in the box which pops into place
ERNoël, 12‐1‐09
5) Label the axes
a. Click on the outer edge of the graph
(so edge becomes light blue double line)
b. Click on “Layout” tab
c. Click on “Axes Titles” in the Labels menu
d. Put the cursor on “Primary Horizontal Axis Title”
e. Make your choice from the drop down menu
f. Type your label for the horizontal axis in the box
Repeat the steps for the vertical axis
g. Click on the outer edge of the graph
(so edge becomes light blue double line)
h. Click on “Layout” tab
i. Click on “Axes Titles” in the Labels menu
j. Put the cursor on “Primary Vertical Axis Title”
k. Make your choice from the drop down menu
l. Type your label for the vertical axis in the box
6) Save the EXCEL file! You can copy and paste this graph into a word document.
Plant Growth
4.5
4
3.5
Height (Inches)
3
2.5
2
Pepper
1.5
1 Sunflower
0.5
0
0 2 4 6
Time (Days)
ERNoël, 12‐1‐09
