Using Microsoft Excel to Create Pie Charts for the Bean Lab



Using Microsoft Excel to Create Pie Charts for the Bean Lab

To create a pie chart:

|Step number |General information (I have experience with Microsoft Office) |Specific information(I have minimal experience with Microsoft Office – please explain |

| | |everything) |

|1 |Select the information to include (type of beans and % comp values) |Place cursor on a cell (box), left click. The box now has a bold outline around it. |

| | |What you want to create is an outline around all of the cells you need. So, put the |

| | |cursor at the top of the bean names, left click, and drag down to highlight all four |

| | |types of beans. Hold the Control key and also highlight the numbers that you need |

| | |(your team’s data) |

|2 |Click the Chart Wizard Icon, select Pie chart, and click next |In the standard toolbar (save, open, print icons), click the picture of a bargraph – |

| | |This is the Chart Wizard icon. Choose a pie chart and click next |

|3 |Click next until you are at step ¾. I want you to Create the Title, Put the Legend at |Click next 1 more time. Click the Title tab and give the chart a title. Click Legend|

| |the bottom, and select percentage and category name. |Tab and change the location of legend to bottom, click Data Labels Tab and select |

| | |percentage and category name. Click next. |

|4 |Save as “My ¼ Pie Chart” and select new sheet. |Click the button “As a new sheet” and type “My ¼ Pie Chart”. Click Finish. |

|5 |Repeat for ½ plot and average % comp data. Save with new name for each sheet. |Repeat for ½ plot and average % comp data. Save with new name for each sheet. |

Using Excel to analyze data:

|Step number |General information (I have experience with Microsoft Office) |Specific information(I have minimal experience with Microsoft Office – please explain |

| | |everything) |

|1 |In the average % comp table, type “Class Average” in the cell next to the last team |Find the table for % comp for your class. The 1st row has the team names. Next to the|

| |name. |last team, type “Class Average” |

|2 |Use either the fx or Autosum buttons to calculate average for the row. |Use the fx button (located in the formula bar, above the spreadsheet) to calculate the|

| | |average for all of the teams in your period. Click on the empty cell where you want |

| | |the information to go. Click the fx button. A new window pops up asking what |

| | |function you want to use. Click average and then click OK. A new window pops up and |

| | |you need to highlight the cells (the row) of information that you what Excel to use. |

| | |A blinking dotted box will surround the cells. If you did the correct thing, click |

| | |OK. Repeat for all bean types |

|3 |Once you have all bean types averaged, create a pie chart as directed above. |Once you have all bean types averaged, create a pie chart as directed above. Label as |

| | |My period average. |

|4 |Repeat these instructions for the other two periods. |Repeat these instructions for the other two periods. |

|5 |Copy & paste bean types into a new area on spreadsheet |Move the cursor to the top of a bean list and highlight the four types (select). |

| | |Click copy. And move the cursor to a free area on spreadsheet. You want to use five |

| | |adjacent columns. |

|6 |Add the three period averages for each and determine a S211 average for each bean |Type in the three period averages for each bean type and determine a S211 average for |

| | |each bean, like you did by creating a period average. |

|7 |Once you have all bean types averaged, create a pie chart as directed above. |Once you have all bean types averaged, create a pie chart as directed above. – Label |

| | |as S211 averages |

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download