BISC 111/113:Statistics and Graphing: Difference between revisions
From OpenWetWare
Jump to navigationJump to search
No edit summary |
|||
| Line 37: | Line 37: | ||
<div style="padding: 10px; width: 725px; border: 5px solid #2171B7;"> | <div style="padding: 10px; width: 725px; border: 5px solid #2171B7;"> | ||
==='''Making a Pie Chart in Excel 2008'''=== | ==='''Making a Pie Chart in Excel 2008'''=== | ||
#Open a new workbook page in Excel 2008. | #Open a new workbook page in Excel 2008. | ||
| Line 45: | Line 42: | ||
#Highlight both category and number data, but not the column labels. To generate a graph, chose "Charts" and then "Pie" from the Menu bar directly above the workbook. Then select the pie chart format you prefer. The farthest left option is both simple and clear, and generates both the chart and its legend, as in the image below.<br> | #Highlight both category and number data, but not the column labels. To generate a graph, chose "Charts" and then "Pie" from the Menu bar directly above the workbook. Then select the pie chart format you prefer. The farthest left option is both simple and clear, and generates both the chart and its legend, as in the image below.<br> | ||
[[Image:PieChartF11.png|500px]]<br> | [[Image:PieChartF11.png|500px]]<br> | ||
==='''Making a Column Graph in Excel 2007 for Vista'''=== | |||
1)Once you have a spreadsheet of raw data, make a new summary table in the Excel sheet (as shown below) for ease of graphing. Create one row with heading titles, a second row for the means, and a third row for the SD calculations. | |||
Revision as of 19:34, 7 June 2011
Making a Pie Chart in Excel 2008
- Open a new workbook page in Excel 2008.
- Enter your Category and Number data in Column A and Column B, respectively.
- Highlight both category and number data, but not the column labels. To generate a graph, chose "Charts" and then "Pie" from the Menu bar directly above the workbook. Then select the pie chart format you prefer. The farthest left option is both simple and clear, and generates both the chart and its legend, as in the image below.
Making a Column Graph in Excel 2007 for Vista
1)Once you have a spreadsheet of raw data, make a new summary table in the Excel sheet (as shown below) for ease of graphing. Create one row with heading titles, a second row for the means, and a third row for the SD calculations.
