Week 8 Graphing in Microsoft Excel

Week 8 Graphing in Microsoft Excel - BioNB 2210, Fall 2011...

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

View Full Document Right Arrow Icon
BioNB 2210, Fall 2011 Graphing in Microsoft Excel The first rule is to remember that Excel is just a tool : it can create a graph for you with very little effort on your part, but there is no guarantee that the graph it creates will be an effective one. Before you even open Excel, you should have a clear mental picture of the graph you want to create. Ideally, draw a rough sketch of the graph you want on a sheet of paper; your task is then simply to make Excel give you the graph you want. The below guidelines give you some help with Excel 2007 and 2003. Excel 2007 Computing averages and standard deviation/standard error To compute the average of a range of values: 1. Select a blank cell in your worksheet 2. Type “=AVERAGE(” 3. Use your mouse to select the range of data that you want to average 4. Type “)”, then hit “Enter”. The number you see displayed in the cell is the average value. To find the standard deviation, follow the steps as above but in step 2 type “=STDEV(” instead. To find the standard error, follow the same steps as above but in step 2 type “=STDEV(__RANGE__)/SQRT(COUNT(__RANGE___))” , where __RANGE__ is the range of data you want to use for your calculation (which you can select with your mouse). Creating a graph The first step is to ask Excel to create a chart in the basic style that you want, such as a bar chart or trend chart. To do this: 1. Go to Insert > Chart and select your desired chart type. 2. Click “Select data” in the ribbon and highlight the data you wish to include in your graph. If the graph is not displaying properly, you may need to add each data series separately, by clicking “Add” and selecting the X and Y values you want for that data series (then repeating for each data series.) 3. If you want your graph to appear in a separate sheet, click the “move chart” button in the upper right corner of the ribbon. Editing and manipulating your graph Now that you’ve created a chart of the correct type, you’ll need to manipulate it to make it look like the exact graph you have in mind. The following table (modified from Werts 2004) presents solutions to a number of common problems in Excel 2007: To change this: Do this: Change type of chart Right-click on the chart (not on any of the
Background image of page 1

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

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

Page1 / 4

Week 8 Graphing in Microsoft Excel - BioNB 2210, Fall 2011...

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

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