Piviot Chart - format x axis

C

Cher062

Hello everyone

I know this must be easy but I am having a brain freeze and just can't seem
to think of how to do this.

I have a piviot chart and the x-axis has dates. It is currently displayed
as "7/31/08" and I want it to be "Jul-08". I've gone into the format area
for the x-axis and chosen number then date and the "Jul-08" as the format but
it doesn't change the format on the chart. It still shows as 7/31/08. Is
there some type of protection perhaps that I need to turn off? HELP I really
need it to be Jul-08
 
D

Debra Dalgleish

The pivot chart number formats are controlled by the field format in the
pivot table.
Right-click a date in the pivot table
Click on Field Settings
Change the Number Format to the date format that you want.
 

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

Date display in Pivot Chart 2
Pivot Charts 5
X axis Scale 8
Format the x axis of a pivot chart, no number tab??? 1
scatter chart won't accept primary axis 4
Can't see the number tab when formatting the X axis on a Pivot cha 2
Trendline 2
Word/Excel Charts x axis to months 5

Top