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.