Creating Pie Charts in Excel
Create the graphs below based on the data provided. You may have to rearrange the data to make the chart work.
Make each chart "As a New Sheet"
GRAPH #1
You spent $187 on food, $800 on rent, $100 on entertainment, $400 in savings, $28 on clothing, $50 on your cell phone bill, $72 on electric, $150 on your car payment.
Use a pie chart that shows where your paycheck went.
GRAPH #2
In a typical day, here's how I spend my time (in hours).
Create a Pie Chart that Represents this data.
| Breakfast | 0.25 |
| Driving to Work | 0.25 |
| Teaching | 4 |
| Planning | 2 |
| Lunch | 0.5 |
| Driving Home | 0.25 |
| Lifting Weights | 0.75 |
| Running or biking | 1 |
| Reading to My Kids | 0.5 |
| Cooking Dinner and Eating | 1.75 |
| Trying to put my kids to bed | 1.5 |
| Watching TV | 2.5 |
| Computer | 1.5 |
| Sleeping | 7.5 |
GRAPH #3
In a class, the grades are made up of 35% test scores, 15% homework, 10% quizzes, 10% projects and 30% Final Project.
Create a Pie Chart that illustrates this, and made the largest portions red and black.
GRAPH #4
In a recent performance of CATS, the audience demographics was measured as follows
0 - 10 years old, 15%; 11 - 18 years old, 45%, 19 - 25 years old 22.5% and 25 and older was 17.5%.
Create a nice pie chart that include the Title "CATS performance demographics".