ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   how do i compile a cumulative sum graph? (https://www.excelbanter.com/charts-charting-excel/51668-how-do-i-compile-cumulative-sum-graph.html)

spazaloikins

how do i compile a cumulative sum graph?
 
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!

Jon Peltier

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!



All times are GMT +1. The time now is 07:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com