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

A

Aaron

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

Andy Pope

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
 

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

Similar Threads

Can't see the number tab when formatting the X axis on a Pivot cha 2
Scatter chart with categories on x-Axis 2
simple chart 0
One extra x axis item that wont go away - can anyone help? 3
Bar Chart in Excel 2010 does not display neither Horizontal axis labels, nor legend 0
Formatting pivot chart axis labels for dates 10
Conditional number format of x-axis based on value? 2
X Y (Scatter) Chart EXCEL 2007 1

Top