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

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

Guest

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.
 

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

Top