View Single Post
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default how do i compile a cumulative sum graph?

If you can compile the numbers into the sheet, then you can chart them,
but you can't expect the chart to do the calculations. By "cumulative
sum" I assume you mean some kind of running total. In the column of
cells next to the data, put a formula that produces the running sum.
Then instead of plotting the original data, plot the calculated sums.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


spazaloikins wrote:

i have been trying to figure out how to make a cumulative sum grqaph from
data in excel which seems impossible. I have 2 lots of 400 pieces of data
therefore am hoping to be able to do it on a computer rather than having to
do it by hand!