Excel_Tutorial_revised

Excel_Tutorial_revised - Excel Tutorial Excel Tutorial By:...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Excel Tutorial Excel Tutorial By: Dave Biegas By: Dave Biegas ISP 203L Sec. 20 TA ISP 203L Sec. 20 TA Excel Tutorial Excel Tutorial Within Excel, type in your data points. Each data point should have two values, these correspond to their respective x and y values. The x-values (x-axis on the graph) represents the independent variable, which will be the radius of the beads. The y-values (y-axis on the graph) represents the dependent variable and in this case, is the measured porosity or whatever else you may have had to calculate. Excel Tutorial Excel Tutorial To graph, click on Insert and scroll down to Chart. If chart is not shown, click on the little arrow on the bottom of the pull down menu to expand the entire menu. This is shown below. Excel Tutorial Excel Tutorial Once you select Chart from the Insert menu, select XY (Scatter). On the right, there is Chart Sub-type. Make sure that the top one is highlighted like in the picture shown. There should be no lines between the points. Select N ext > on the bottom row of tabs. Excel Tutorial Excel Tutorial On the top of the menu, you will see Data Range and Series tabs. Select the Series tab. Next click on the A dd button to add a series of data points. Excel Tutorial Excel Tutorial Here, you choose a name that best represents your data set (e.g. experimental). Type that in the Name: dialog box. Next, select the x data points, which will be entered in the X Values: dialog box. To do this, click on the little red arrow on the right side of the dialog box. Excel Tutorial Excel Tutorial To select the data points for the x-values, hold down the left mouse button on the top value of your x-values (NOT including the text label above it). the top value of your x-values (NOT including the text label above it)....
View Full Document

This note was uploaded on 11/11/2011 for the course ISPL 203 taught by Professor Staff during the Spring '10 term at Michigan State University.

Page1 / 27

Excel_Tutorial_revised - Excel Tutorial Excel Tutorial By:...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online