Culmative Graphs
 

Hi
I have many spreadsheets where I enter time based data and then want a graph
to display the culmative of the data.
ie
Jan 10
Feb 22
Mar 35
Apr 3
I would then want the graph to display values 10, 32, 67, 70
Is there any way of doing this without having a further calculated column
for the culmative amounts (10+22, 10+22+35 etc)? Which is fine for one
example but becomes very cumbersome for 50 datasets.
ta

Culmative Graphs
 

Add an additional column with formula. For example In cell C2 enter
formula..and copy that down..
=SUM(B$2:B2)

If this post helps click Yes
---------------
Jacob Skaria


"NomadPurple" wrote:

Hi
I have many spreadsheets where I enter time based data and then want a graph
to display the culmative of the data.
ie
Jan 10
Feb 22
Mar 35
Apr 3
I would then want the graph to display values 10, 32, 67, 70
Is there any way of doing this without having a further calculated column
for the culmative amounts (10+22, 10+22+35 etc)? Which is fine for one
example but becomes very cumbersome for 50 datasets.
ta

Culmative Graphs
 

Oops.. I initially thought you are looking for a formula..

http://www.ozgrid.com/Excel/stacked-column.htm

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Add an additional column with formula. For example In cell C2 enter
formula..and copy that down..
=SUM(B$2:B2)

If this post helps click Yes
---------------
Jacob Skaria


"NomadPurple" wrote:

Hi
I have many spreadsheets where I enter time based data and then want a graph
to display the culmative of the data.
ie
Jan 10
Feb 22
Mar 35
Apr 3
I would then want the graph to display values 10, 32, 67, 70
Is there any way of doing this without having a further calculated column
for the culmative amounts (10+22, 10+22+35 etc)? Which is fine for one
example but becomes very cumbersome for 50 datasets.
ta