In this assignment, you will expand on chart-generation using the work you did in the previous assignment. Open the last assignment, save it as Charts_2_Your_Name, and complete the following.
Part 1:
1. Add a vertical column chart and a horizontal bar chart to the spreadsheet using the same data.
2. All three charts should be in the same worksheet, sized the same, and next to each other.
Part 2:
3. Pick at least 10 people to participate in a survey regarding your charts. Ask each person to vote on which
chart they like best. You can survey classmates, workmates, family, or friends.
4. Create a new table with the results of your survey somewhere below the Gasoline Prices information.
Your table will look something like this (these votes are just sample numbers).
Chart Type # of Votes
Line 4
Vertical 2
Horizontal 4
5. Generate a pie chart to display the results of your survey.
6. Save and submit your spreadsheet, making sure it meets the guidelines below.
Points
Possible
Points
Earned
Line, vertical, and horizontal charts all display correct data. 6
Line, vertical, and horizontal charts are all sized the same and next to each
other.
4
The pie chart represents survey results of 10 or more people. 10
Total Points 20