Yes :-)

You are correct in that empty cells (or text cells) in a date field will
prevent you from grouping dates.

The way round what is hapopening is to use a dynamic range that will
automatically piclk up the extra data. Instructions can be found he-

http://www.contextures.com/xlPivot01.html

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"thornomad" wrote in message
...
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