Charting a Cumulative Sum

[atom]

I have a column of cells with cash amounts and there are several cells
per day, some positive and some negative. I want to create a chart that
graphs these numbers as a Cumulative Daily Sum (as opposed to a chart
simply containing each individual amount).

I know how to write a Cunulative Sum formula, but I'm hoping there's a
more elegant solution than filling tons of cells with formulas for each
day's total and charting from that.

thanks.

 

[Debra Dalgleish]

You could use a PivotTable to summarize the data, and create a chart
from the PivotTable.

There are some instructions, and links to information here:

http://www.geocities.com/jonpeltier/Excel/Pivots/pivotstart.htm