How to show a cumulative value over time in a pivot chart.

[cpoole]

hello, I currently have a spreadsheet with (among other things) the
following columns:

year, date, distance

I want to create a pivot chart that shows the cumulative distance over
time by year.

I can easily create a bar chart with this information now and show
each year in a series, but i'd like to figure out how to show a
rolling year-to-date total.

Any help would be greatly appreciated.

 

[cpoole]

No takers?

In case I wasn't clear, I want to show months or weeks on the x axis
and then distance on the y axis. I want a series for each year in my
data set and I want the value to be cumulative so that I can compare
the rate of growth on a year-to-year basis.


Thanks in advance!