Cummulative graph

G

Guest

Hi,
If I have a series of data (% work per month) and I want to create a graph
showing it but each month will include the former months.
for instance: 1 10
2 20
3 30

will show 1 10
2 30
3 60

Thanks,
Assaf
 
M

MartinW

Hi Assaf,

In your example put this in column C and drag down as far as is needed.
=IF(B1="","",SUM(B$1:B1))

HTH
Martin
 

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

Similar Threads


Top