Graphing-with-Excel

Graphing-with-Excel - Graphing with Excel 1 Table of...

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

View Full Document Right Arrow Icon
Graphing with Excel 1 1 Table of Contents 1. Graphing Data 1.1. Starting the Chart Wizard 1.2. Selecting the Data 1.3. Selecting the Chart Options 1.3.1. Titles Tab 1.3.2. Axes Tab 1.3.3. Gridlines Tab 1.3.4. Legends Tab 1.3.5. Data Labels Tab 1.4. Selecting the Chart Location 1.5. Changing an Existing Graph 1.6. Changing the Look of the Graph 1.6.1. Editing Titles 1.6.2. Formatting Axes 1.6.3. Changing Data Markers 2. Graphing Multiple Data Series 3. Fitting a Curve to a Data Series 4. Adding Error Bars to a Data Series 5. Estimating Uncertainty in Slope of a Linear Trendline 5.1. Drawing the Line 5.2. Rotating the Line 5.3. Estimating the Slope of the Line 6. Glossary of Excel Terms
Background image of page 1

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

View Full DocumentRight Arrow Icon
Graphing with Excel 2 2 1. Graphing Data 1.1. Starting the Chart Wizard When the data worksheet has been set up (the data entered and the columns labeled), it is time to graph the data. Before starting a graph, it is important to have a clear idea of what values go on what axis. Usually, the independent variable goes on the x-axis and the dependent variable goes on the y-axis. For example, consider a data series that measured the distance from the motion detector to a glider which moved along a track. To know the distance to the glider, one must pick a particular time. The distance depends on the time. The independent variable is time and the dependent variable is distance. Therefore, the distance versus time graph of that data would have the time on the x-axis and the distance on the y-axis. To create a graph, click the Chart Wizard button in the area beneath the top menu bar or go to the top menu bar, click Insert and select Chart . The Chart Wizard will go through the different steps of making a graph. In the window that pops up, the Chart Type window, choose the XY (Scatter) type from the list of standard graph types. In the Chart sub-type area make sure the highlighted image is the one without any lines or curves, as shown in Figure 1 . Click the Next button when done. Figure 1: Chart Wizard with the Chart Type window showing the Standard Types tab with all the possible types of graphs. The XY (Scatter) graph is selected.
Background image of page 2
Graphing with Excel 3 3 1.2 Selecting the Data In the window that pops up click the Series tab. Here is where the data will be assigned to the x- and y-axes. If there are any data series already entered, click on each one in the Series area and then click the Remove button until there are none left. Click the Add button to begin a new data series. There are three fields on the right-hand side of the widow: Name field, X Values field, and Y Values field. Click the Data Range box next to the X Values field. The Source Data window will collapse to a small window only showing the X Values field, as shown in Figure 3 . Go to the worksheet with the data and select the data for the x- axis. A dashed box around the cells indicates what has been selected. If a mistake is made in selecting data, click in the field in the shrunken Source Data window and delete the range
Background image of page 3

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

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

This note was uploaded on 12/14/2009 for the course PHYS PHYS-102 taught by Professor Kikkawa during the Spring '09 term at UPenn.

Page1 / 16

Graphing-with-Excel - Graphing with Excel 1 Table of...

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

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