Periodic Variation in Properties
· Bar or Scatter Graphs
· Titles
· Label Axes
· Label each element symbol above each bar or point (Ex. Atomic # 1 = H)
Directions for Graph #1:
1. Open Microsoft Excel
2. In Cell A1, type Atomic #
3. In Cell B1, type O atoms per E
4. In Cells A2 down to A21, type the numbers 1 to 20. In Cells B2 down to B21, type the data as
shown in the table below:
Atomic # / O atoms per E1 / 0.5
2 / 0
3 / 0.5
4 / 1
5 / 1.5
6 / 2
7 / 2.5
8 / 1
9 / 0.5
10 / 0
11 / 0.5
12 / 1
13 / 1.5
14 / 2
15 / 2.5
16 / 1
17 / 0.5
18 / 0
19 / 0.5
20 / 1
5. Using the mouse, highlight all of the values that you just input: Cells A2-A21 and B2-B21.
6. Click on the “Insert” tab and then click on “Scatter” (or Bar or Column if you choose). Choose a Scatter plot with points and connecting lines. Choose a bar graph that will have one bar for each atomic #.
7. Click on the graph and then select the “Layout” tab. Click on the “Chart title” button and
choose “Above graph.” Type in “Trends in a Chemical Property” as the title or some descriptive title of your choosing.
8. Next under the “Layout” tab, choose the “Axis titles” tab. Choose “title below axis” for
primary horizontal axis title. Type in “Atomic Number of Element” for the axis display.
9. Under the “Layout” tab, choose the “Axis titles” tab. Choose “rotated title” for primary
vertical axis title. Type in “Number of O atoms per Atom of Element.” for the axis display.
10. Under the “Layout” tab, choose “Legend” and then click on “None.”
11. Under the “Layout” tab, choose the “Data labels” button and choose “Above.” You should
see numbers appear above every point on your graph. Click on each number and
delete it, replacing it with the element symbol. Use the periodic table to help you.
(Atomic # 1 is H. Atomic #2 is He. etc.)
12. Under the “Insert” tab, choose “Text box.” Then add a text box to the right of the chart and
type your name in it.
13. Copy and paste your chart into a Microsoft Word document.
Directions for Graph #2:
1. On the bottom of the Excel spreadsheet, click on “Sheet 2” to open a blank spreadsheet.
2. In Cell A1, type Atomic #
3. In Cell B1, type Boiling Point (K)
4. In Cells A2 down to A21, type the numbers 1 to 20. In Cells B2 down to B21, type the data as
shown in the table below: (Note: there is no value for 6 because carbon’s boiling point is an
extremely high value.
Atomic # / Boiling Point (K)1 / 21
2 / 4
3 / 1600
4 / 2780
5 / 2800
6
7 / 77
8 / 90
9 / 85
10 / 27
11 / 1162
12 / 1390
13 / 2600
14 / 2950
15 / 553
16 / 718
17 / 239
18 / 87
19 / 1030
20 / 1760
5. Using the mouse, highlight all of the values that you just input: Cells A2-A21 and B2-B21.
6. Click on the “Insert” tab and then click on “Column” (or Scatter or bar).
7. Click on the graph and then select the “Layout” tab. Click on the “Chart title” button and
choose “Above graph.” Type in “Trends in a Physical Property” as the title or some descriptive title of your choosing.
8. Next under the “Layout” tab, choose the “Axis titles” tab. Choose “title below axis” for
primary horizontal axis title. Type in “Atomic Number of Element” for the axis display.
9. Under the “Layout” tab, choose the “Axis titles” tab. Choose “rotated title” for primary
vertical axis title. Type in “Boiling Point (K)” for the axis display.
10. Under the “Layout” tab, choose “Legend” and then click on “None.”
11. Under the “Layout” tab, choose the “Data labels” button and choose “Outside End.” You
should see numbers appear above every bar on your graph. Click on each number and
delete it, replacing it with the element symbol. Use the periodic table to help you.
(Atomic # 1 is H. Atomic #2 is He. etc.)
12. Under the “Insert” tab, choose “Text box.” Then add a text box to the right of the chart and
type your names in it.
13. Copy and paste your chart into your Microsoft Word document and print out both graphs.
Answer the follow-up questions that are on the document titled Periodic Trends Graphing Activity. You must turn in your sorted element data cards, graphs, and questions together.