Been searching for almost 30 minutes now. Ho0w do I create a cumulative chart?
What I want to make is a chart that shows how people score points in time.
It has to do with the upcoming EC soccer.
A player can get 0,1 or 3 points depending on how well they've predicted the
games. I want to create a graph where one can follow the cumulative score in
time. Example game 1 gave 1 point, game 2: 3, game 3: 0, game 4: 3. So I want
to see the graph go to 1, 4,4, 7 points.

I could make a row where I calculate all the cumulative scores...but is
there a quicker way to do what I want?

Hope I explained it well enough.
Thx in advance for (trying to) all the help.

Hi,

Charts are good at displaying values rather than manipulating them.
As you suggest use a separate column to accumulate the data to be plotted.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Nico" wrote in message
...
Been searching for almost 30 minutes now. Ho0w do I create a cumulative
chart?
What I want to make is a chart that shows how people score points in time.
It has to do with the upcoming EC soccer.
A player can get 0,1 or 3 points depending on how well they've predicted
the
games. I want to create a graph where one can follow the cumulative score
in
time. Example game 1 gave 1 point, game 2: 3, game 3: 0, game 4: 3. So I
want
to see the graph go to 1, 4,4, 7 points.

I could make a row where I calculate all the cumulative scores...but is
there a quicker way to do what I want?

Hope I explained it well enough.
Thx in advance for (trying to) all the help.