View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Cumulative chart

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.