How do I create a "cumulative" chart in Excell, which ADDS #'s ?

[Guest]

I simply want to create a chart which ADDS each numerical value to the one
preceeding it, resulting in a graph which, by definition, keeps increasing in
value....rather than one which goes up and down to reflect each individual
value entered.

 

[Guest]

Hi,

This is not a charting issue, instead you need to set up your data area to
handle this and then chart that. For example if you have your numeric values
in cells B10:M10, then in B11 enter the formula =B10+A10 (where nothing is
in cell A10) and copy it across to column M. Then chart this row of data
rather than row 10.

 

[Ron Coderre]

Since what you're describing is a feature of a Pareto Chart....

Perhaps the Pareto Plotter at this website will help:
http://www.contextures.com/excelfilesRon.html

Is that something you can work with?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)