Excel Guide #1: Creating Graphs

Making graphs in lab is very important because students may notice trends not easily seen in a column of data. All plots this semester, with the exception of histograms, will be scatter plots. Make sure NOT to use line plots which only allow one variable to be graphed against data point numbers.

Below there are two different ways to create graphs in Excel.

Graphing Method #1:
Graphing Method #2:

Graphing Method #1:

1. Highlight the data columns that you want to be graphed.

2. After highlighting the columns, click on the “Insert” tab and click on the option for a scatter plot (the “Scatter” button).

 photo 1_zps05ed69ea.jpg

3. After clicking on the “Scatter” option, click on the option under “Scatter With Only the Markers” in order to create a graph without a line.

3 photo 2_zps31fbb933.jpg

Graphing Method #2:

Sometimes there are circumstances when you need to plot multiple variables into a plot or need to switch the axis.

1. Click on the “Insert” tab and click on “Scatter” and then the option for the graph without the markers. A blank graph will be shown on excel.

2. Right click on the blank graph and click on “Select Data” to put data into the plot.

2b photo 5_zps11f3e82c.jpg

3. When the “Select Data Source” screen pops up, to add data to the plot, click on the “Add” button.

3b photo 6_zps0ce94331.jpg

4. After clicking the “Add” button, the values for the x and y axis can be added to the graph. To add the x and y values to the graph, in “Series X values” line highlight the column for the x axis and for “Series Y values” highlight the values for the y axis.

4b photo 7_zpsb51afb49.jpg

5. To add more values to the graph, repeat step 4 for each of the x and y axis.

6. The graph should look like this when you are done.

6b photo 8_zpsca9656b0.jpg