hello,

i'm totally square to graphs so bear with me...

I want to graph a relative frequency distribution....


I have 2 columns which contain the data i want to graph.

The first column has numbers ranging from -105 to -250 (which multiple #'s can be found)

The 2nd column has strictly "W" or "L" (I'm concerned mostly with "W" however a % of "W" compared to the sum(W+L) would be better...


What i want to do is setup 20 categories (say -105 to -115, -116 to -125, -136 to -145, etc.) and have these designations along the Y-axis.

And i want to plot the corresponding number of W's (or % of W's) in each category..

So for instance...

-105 to -115 .... 6 W's (or 18%)
-116 to -125 .... 8 W's (or 22%)
-126 to -135 .... 13 W's (or 30%)
-136 to -145 .... 27 W's (or 61%)

etc.. to include about 20 or so 'groups'


1) What do i need to do to my sheet data to setup these categories so they may be used in the graph?

2) How do i get the Categories to show up on the Y-axis and the Frequency of "W" on the x-axis (in their appropriate intervals)?


I realize this is a large and seemingly complex question..
it probably looks worse than it it.. i tried to be very detailed in what i'm looking for.. any help is much appreciated!!