Can't see the number tab when formatting the X axis on a Pivot cha

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.

have you set the cell format?
right-click cell>number tab>category:custom
--
Regards,
Linda


"Aaron" wrote:

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

Not sure I understand you? As noted in my original question I tried
formatting the cells in the source data and the cells in the pivot table.
But the chart is not looking at the formating, it is looking at the value.
It seems that the catagory axis can't be formated by number, the whole tab is
gone. Not sure where I'm going wrong here.

"linda" wrote:

> have you set the cell format?
> right-click cell>number tab>category:custom
> --
> Regards,
> Linda
>
>
> "Aaron" wrote:
>
> > 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.