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

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.
 
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
Formatting pivot chart axis labels for dates 10
Remove the weekends from a pivot chart x axis 0
X Y (Scatter) Chart EXCEL 2007 1
Pivot Chart - X-axis labels when adding data 0
excel2007 pivot table chart x-axis 1
Rotate the Pivot Chart? 1
Conditional number format of x-axis based on value? 1

Top