{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Excel_Tutorial_revised - Excel Tutorial Excel By Dave...

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

View Full Document Right Arrow Icon
Excel Tutorial Excel Tutorial By: Dave Biegas By: Dave Biegas ISP 203L Sec. 20 TA ISP 203L Sec. 20 TA
Background image of page 1

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

View Full Document Right Arrow Icon
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.
Background image of page 2
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.
Background image of page 3

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

View Full Document Right Arrow Icon
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.
Background image of page 4
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.
Background image of page 5

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

View Full Document Right Arrow Icon
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.
Background image of page 6
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). With the
Background image of page 7

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

View Full Document Right Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}