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.
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).
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.
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.
3. When the “Select Data Source” screen pops up, to add data to the plot, click on the “Add” button.
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.
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.