EXCEL GRAPHING (2007 Version)

Objective: curve-fitted linear graph. Other types of graphs: specified during the selection of the trend line.

1. Enter the data (2 columns). Highlight the data columns (including the column headings)

2. Click on the “Insert” on the menu bar on top of the page. This opens a number of options grouped in several areas.

3. Select the “SCATTER” option in the “Charts tools” group. If the goal is to make a graph with a trend line, select the scatter without a connection line. If the goal is to show how the experimental data connect with one another, select the scatter that has a line that connects the experimental dots.

4. Click on the “Layout “. This opens the possibility to:

· Put labels on the various parts of your graph (using tools in the “Labels” group)

· Decide the information the axes will provide (using tools in the “axes” group)

5. If a trend line is needed, still in the “Layout” tab, click on the icon that shows the picture of a graph with a linear trend line on it.

6. In order to have a large graph, right-click on the graphic outside the plot area. A dialogue box opens up. Click on “Move Chart” choice. Another dialogue box opens up. Select the “new sheet” option.

7. In order to label the axes and show the grid lines, click on the “Layout“ tab and make the desired selections.

8. In order to remove useless empty space on the graph and show the minor tick marks, point the cursor on the x or y axis and right-click on it. A number of options opens up. Click on the “fixed” bubbles and choose where you want the minor tick marks to be displayed. The same process may be followed for major tick marks if gridlines are not shown on the graph.