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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- convert microsoft excel to pdf
- how to create a spreadsheet for dummies
- how to read stock charts for dummies
- how to read stock charts for beginners
- how to create an outline for essays
- how to create a website for business
- microsoft excel to pdf
- how to create desktop icons for apps
- free pie charts and graphs
- multiple pie charts in excel
- how to create a blog for free
- pie charts with percentages