Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a combination graph with stackedColumns+lineGraph | Charts and Charting in Excel | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
How to make cumulative totals appear on a graph | Excel Discussion (Misc queries) | |||
bar, line and cumulative bar graph in one chart | Charts and Charting in Excel | |||
Graph Axes | Excel Discussion (Misc queries) |