I have a piviot chart and the x-axis has dates. It is currently displayed
as "7/31/08" and I want it to be "Jul-08". I've tried to change the "Field
Settings" in the pivot table but the dates still show as 7/31/08 in the
chart. HELP!! I'm pulling my hair out!!

Hi,

Since you didn't tell us what version of Excel, lets assume 2003 -

In the pivot chart right-click on the field button for the Date field,
choose Format Pivot Chart Field, click Number, and either use one of the
built-in date formats or choose Custom and enter your own.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Erin" wrote:

I have a piviot chart and the x-axis has dates. It is currently displayed
as "7/31/08" and I want it to be "Jul-08". I've tried to change the "Field
Settings" in the pivot table but the dates still show as 7/31/08 in the
chart. HELP!! I'm pulling my hair out!!

Yes, I'm using 2003. When I right click and go to "field settings" I don't
get an option to choose anything but these: SUM, Count, AVG, MAX etc. I've
changed the cel format to be MON-YY too. Any other ideas?


"Shane Devenshire" wrote:

Hi,

Since you didn't tell us what version of Excel, lets assume 2003 -

In the pivot chart right-click on the field button for the Date field,
choose Format Pivot Chart Field, click Number, and either use one of the
built-in date formats or choose Custom and enter your own.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Erin" wrote:

I have a piviot chart and the x-axis has dates. It is currently displayed
as "7/31/08" and I want it to be "Jul-08". I've tried to change the "Field
Settings" in the pivot table but the dates still show as 7/31/08 in the
chart. HELP!! I'm pulling my hair out!!