Badly need help to put four categories in one pie chart

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

--
shadow_321
-----------------------------------------------------------------------
shadow_3211's Profile: http://www.excelforum.com/member.ph...nfo&userid=2878
View this thread: http://www.excelforum.com/showthread.php?threadid=48473

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 wrote:

> The problem is getting the 4 groups on the same Pie Graph I don't know
> how to go about it.
>
> I am taking a correspondence course, the course is MEL4E-A Key question
> 8 for anyone that maybe has did this course
>
> Here is the scenario-
>
> The Table below lists baseball team standings. Create a frequency table
> 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 stick
> when i post.
>
>

--
shadow_3211
------------------------------------------------------------------------
shadow_3211's Profile: http://www.excelforum.com/member.ph...fo&userid=28785
View this thread: http://www.excelforum.com/showthrea...threadid=484730