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