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.