Date display in Pivot Chart

  • Thread starter Thread starter Erin
  • Start date Start date
E

Erin

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.
 
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?
 
Back
Top