Excel chart question

[darrenstraight]

I know this is a long shot and maybe it's not the best place to ask but I having a fealing somebody might know.

Ok here's what I would like to do in an excel chart:

I would like to know how to combine all the points for a certain game into just one colum for each game on the chart for example the two shooting points get combined to make 15 points in one colum.

Here's my excel chart so you know what I'm talking about.

http://www.darrenstraight.sizzly.com/excel/points.xls

Thank you for your help.

[wefancyu]

i don't get your meaning of 'combine'...

i asume you can create a column for players and columns for scores of different games and use sum function to add them up.



is this what you want?

[darrenstraight]

Mmmm...

Not really as I still wanted the same layout.

Never mind as I think I've found out another way of doing it but here's an image of the chart for others to see anyway.

Thanks wefancyu for trying to help.