I used data like this:

Date Item Income
31/12/04 10:00:00 Nuts 23.19
5/1/05 09:00:00 Bolts 35.23

etc

I set up the pivottable with pivotchart report with Date as the row
heading, Item as the column heading and Sum of Income in the Data area.
I then clicked on the Date field and used the Date drop-down menu and
Group to group by months, the resulting chart showed the months on the
category axis. I don't see why your data shouldn't work, just make
sure your date cells are formatted as dates and not text or something
peculiar.

Andrea Jones
www.stratatraining.co.uk


Kamal Hood wrote:
I just want to group my dates in a pivotchart by months or weeks to
get
sales or weight sums by the month or week. Problem is that the chart
won't
allow me to group the dates--it says that this type of data cannot be
grouped. why? why? why?

the dates in the cells also have time info:
i.e.
7/1/2004 9:53:07 AM

so when I put the Date field into the Category area of the chart it
plots
every row down to the second! I'm lost and confused and searched the
whole
newsgroup but can't find any postings of this same issue.

it seems like something common. can anyone help?

thanks,
kamal