Bemidji,

I've found a solution to a related problem ( my 10/20 post). Regarding
your question on date format, it seems that if you Group by Day in a
PivotTable, the dates are converted to text/labels. I think that's why
changing the Field Settings Number format doesn't do anything. Another
problem with this is the Field Settings/Advanced/AutoSort goes by day (as
text) first and then by month name, which is useless:

1-Nov
1-Oct
1-Sep
10-Nov
2-Nov
3-Jan
etc.

A workaround for getting it to sort properly is to turn off AutoSort (set to
Manual), refresh data, then re-Group by Day. If your source data is actual
dates, and is sorted by date, the PivotTable seems to retain this sort order.

Jerry Cooper, CMA
________________

"Bemidji" wrote:

Good morning Karen:

What you suggested absolutley works. Thank you so much.

The date format (after I followed your instructions) now shows up as
ex. 27-Apr, I would like it to show the date in perhaps the mm/dd/yy
format. Is there a way I can do this? I right clicked on "Field
Settings", and then "Number", and selected what I wanted, but it does
not change the format.

The version of Microsoft Excel I am using is Excel 2003. Thanks.


KarenF wrote:
Hi Bemidji,

What version of Excel are you using? Also, perhaps the dates are not
grouping together properly as they have the date AND time stamp. In your
pivot chart (or in your pivot table), have you tried:

1 - right clicking on the date label

2 - choosing Group and Show Detail from the shortcut menu

3 - choosing Group from the submenu

4 - from the Group list, ensure your date range (starting at and ending at)
at the top encompasses your date range for your chart, and

5 - from the "By" list, selecting Days (note it is possible that more than
one grouping method can be selected here, so ensure that the only "by" method
that is clicked is Days).

6 - click on OK.

Your information should now be grouped on a daily basis, regardless of any
time intervals within each date.

Hope this helps Bemidji.

Take care,

Karen.

"Bemidji" wrote:

Any ideas?? Help!!!!!

Bemidji wrote:
Good morning:

I am having an issue with a pivot chart and how it is displaying the
data. The 3 types of data that I have included in the pivot chart
include the following:

Time and Date
Downtime Reason
Minutes Down


The problem comes with the Time and Date. The data has been exported
from Microsoft Infopath to an Excel spreadsheet, and when the data is
entered by an employee, a Time and Date stamp is created for each of
the downtime reasons. The Pivot Table is viewing these as separate
occurrences, which they are, but I need to lump the data by date. I am
not concerned with time.

I want the pivot chart to show all of the occurrences of a downtime
reason lumped to a single date igf they occurred on that date. Each
column should be a different date. Any ideas?? Thanks in advance.



I have created a pivot chart