Herbert, thanks for this. It *almost* worked, which I consider quite
an achievement given that I had never heard of pivot tables.

Two problems remain:

- As I said in my first post, I want to add up the balances of three
bank accounts over the period of a year and plot them in a graph. My
data points are the balances for each account for every day there has
been a transaction (typically about once or twice a week). These
transactions don't always take place on the same days for each of the
accounts. This means that, for example, account A has transactions
(hence, data points) on 12 and 18 July, while account B has a
transaction on 16 July. Adding up the balances of accounts A and B
doesn't work for 16 July, because on that day the balance of account A
is seen as zero (no transaction, no data point). Whereas in reality
the balance of account A on 16 July is still the same as it was on 12
July.

- There are days when an account has had more than one transaction,
resulting in more than one data point. What the pivot table does is
add up all data values for that day in a particular account, as
opposed to only the final one of the day.

I'm not sure if these are problems that can be dealt with easily, or
whether they perhaps suggest that a pivot table was not the solution
after all...

Cheers,
Richard