Date display in Pivot Chart

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

Shane Devenshire

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.
 
E

Erin

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Piviot Chart - format x axis 1
Pivot Charts 5
Format the x axis of a pivot chart, no number tab??? 1
Line Chart for Dates 1
Can't see the number tab when formatting the X axis on a Pivot cha 2
Pivot Chart- 2 unrelated series on 1 chart 4
Invalid detail on axis 1
Formatting pivot chart axis labels for dates 10

Top