Format the x axis of a pivot chart, no number tab???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My x axis has dates like 08/31/07. I want to change the formatting to
Aug-07. For some reason when I format the X axis I can't see the "Number"
tab. I can see it fine for the Y axis or when I format the X axis on a
regular chart, but not the X axis on a pivot chart. I also tried changing
the formatting on the source data and the source pivot table. Nothing works
for the pivot chart except changing the source data to text which I don't
want to do because I need them in number format for other calculations.
Please help.
 
Hi,

Go to the pivot table and change the Number of the Field setting. The
changed formatting will be reflected in the chart.

Cheers
Andy
 
Back
Top