Hi,

Assuming your data table is in the range A1:Z30, so you have 29
different players. You will need to produce summary information from
which to construct your chart.

Place the following formula in cells below you table. Once you
understand how to create the summary and chart I suggest you move the
formula to another worksheet so you an continue to expand your data
table. Remember to also expand the formula though.

B33: =Yes
B34: =No

C32: =C1
C33: =SUMPRODUCT(($A$2:$A$30=$B33)*(C$2:C$30))
C34: =SUMPRODUCT(($A$2:$A$30=$B34)*(C$2:C$30))

Select C32:C34 and drag across to column Z to extend the summary table.

Now create a normal clustered column chart on the range B32:Z34

Cheers
Andy

Kepf wrote:
wow... So maybe it isn't so crazy that I was stumped on this one.

Well, can anybody tell me if they think what I want to do is even
possible?

If not, would there be a better way I could set this up to achieve the
same results?





--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info