Culmative Graphs

N

NomadPurple

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
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top