Chart question, I am stumped:


Column A either says "yes or no"
Column B is the name of the player
Columns C through Z are the years, with a number that corresponds with
how many I have of that player for that year. (1987, 1988, 1989, etc)

Kinda like this:
----------------------------------------------------------------------------

A B C D E F-----Z

sell? playername 1987 1988 1989 1990
no Barry Bonds 4 6 2 1
yes Ken Griffey Jr 6 1 3 3
yes Sammy Sosa 1 1 5 2
no Barry Larkin 1 1 2 1
---------------------------------------------------------------------------
My question is, How do I make a column bar graph that adds up all of
column C, all of column D, etc etc through Column Z (by the year), to
produce a graph that shows:

one axis: number of cards
the other axis (the columns): year, but divided into the yes/no of
column A.

kinda like this:
---------------------------------------------------------------------------------
n
u
m
b
e (then in here, the bars are
r divided in two by the yes/no answer)

o
f

c
a
r
d
s 87 88 89 90 91 92 93-----

year by year


---------------------------------------------------------------------------------------------

Sorry if this came off as a little confusing, but obviously I am a lot
confused. :)


--
Kepf
------------------------------------------------------------------------
Kepf's Profile: http://www.excelforum.com/member.php...o&userid=30611
View this thread: http://www.excelforum.com/showthread...hreadid=542996