Badly need help to put four categories in one pie chart

[shadow_3211]

The problem is getting the 4 groups on the same Pie Graph I don't kno
how to go about it.

I am taking a correspondence course, the course is MEL4E-A Key questio
8 for anyone that maybe has did this course

Here is the scenario-

The Table below lists baseball team standings. Create a frequency tabl
and a pie graph of the teams that have 80 or more wins, 70-79 wins
60-69 wins, and fewer than 60 wins.





Wins Losses

New York 83 53
Boston 79 58
Toronto 68 69
Baltimore 61 75
Tampa Bay 53 82
Chicago 73 64
Kansas City 70 65
Minnesota 71 66
Cleveland 62 76
Detroit 34 102
Oakland 82 55
Seattle 80 57
Anaheim 67 70
Texas 63 75

Sorry about the formatting it was typed out in order. But doesn't stic
when i post

 

[Jon Peltier]

Assuming your data is in A1:C15 (don't skip a line betweein the header
row and the data), Enter these values in E2:E4:

80
70
60

If you want, you can enter a label like "<60" in E5, and a label like
"Frequency" in F1.

Select the whole range F2:F5, and type this formula:

=FREQUENCY(B2:B15,E2:E4)

Hold dowm CTRL+SHIFT when pressing Enter, so the formula becomes an
array formula. If you do it correctly, Excel displays the formula in
curly braces, like this:

{=FREQUENCY(B2:B15,E2:E4)}

Don't type these yourself; Excel will treat it as an error.

The range E1:F5 now looks like this, ready for plotting:

Frequency
80 4
70 6
60 2
<60 2

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[shadow_3211]