Hi,

Let's suppose that Column C contains your positions starting from Row 2.
In some other column, say F2 to F10, enter the numbers 1, 2, ... 9.
In G2, enter the following formula and hit ENTER.
= COUNTIF($C$2:C10000,"="&F2)
Click on G2, move the cursor to the bottom right corner of G2 (the cursor
will turn into a "+" symbol) and doublt-click the left-button.

Columns F and G respectively show the positions (1 thru 9) and the number of
times those positions are achieved.

Make a Column Chart with G2:G10 (Values) versus F2:F10 (Category X-axis
Labels).

Regards,
B. R. Ramachandran

"chew" wrote:

>
> This is a bit tricky to explain but here goes.
>
> I play poker and keep a record of my position (1st-9th) for each
> Tournament in excel. eg
>
> Date-----Game-----Position-----Prize-----Balance-----etc.-----etc.
> 1st Jan---$10---------2---------$30------$130
> 3rd Jan---$10---------1---------$50------$180
> 10th Jan--$10---------7----------$0------$170
> etc.
> etc.
>
> I would like to make a column chart showing the spread of my
> positions.
> With 1st through to 9th along the bottom and the number of times I have
> got that position up the side. (sorry, don't know my x's from my y's!)
> Hopefully then when I continue to enter my data for each new tournament
> the chart updates itself.
> Is this possible?
>
> PLEASE HELP!
>
> DH
>
>
> --
> chew
> ------------------------------------------------------------------------
> chew's Profile: http://www.excelforum.com/member.php...o&userid=33061
> View this thread: http://www.excelforum.com/showthread...hreadid=528750
>
>