View as Microsoft Word* | View as PDF
|
How to Graph the Favorite Beans Survey |
- Open a spreadsheet program.
- Enter data from the favorite bean survey using the template. See the example below:
|
Arizona |
Washington |
Pennsylvania |
|
Baked |
4 |
5 |
9 |
| Green |
5 |
1 |
8 |
| Refried |
12 |
3 |
4 |
| Jelly |
1 |
15 |
6 |
- Click and drag across all the data cells (including the state names and type of beans) to select them.
- Click the Chart Wizard button in the toolbar.
- Click Column (type of graph). Point and click the next button two times.
- Enter a Chart Title: Favorite Beans. Press the tab button.
- Enter the X axis: Type of Beans. Point and click the next button.
- Click the Finish button.
Your graph should look similar to the following sample graph:

< Return to The Great Bean Race