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

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.

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

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Aaron" wrote in message
...
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.