Hi,

I had a wonderful suggestion from this group to use a pivot table to group
my transactions by month in a chart ... awesome.

now, however, i can't figure out an easy way to create a pivot table that
will allow me to continually add data at the end of my list ... as more
transactions come in. I appreciate that I have to use the "refresh data"
button ... however, I am finding that if I create a pivot table selecting my
entire data worksheet as the source (even the empty cells) it won't let me
group my DATE field by month ... I believe it is because I have "empty
cells".

If I go ahead and select only the cells with data in them, however, each
time I add a new transaction, I have to go back into the wizard and
reestablish my data fields.

Is there any easy way around this ? Thanks.

D