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!!