Pivot Charts

[Cher062]

Sorry if this is doubled we lost power when I hit send and I don't see it

I have a pivot chart where the x axis has dates. It currently is displayed
as 7/31/08 and I need it to be Jul-08. I have gone into the format area
chosen number then date and chosen the Jul-08 format but it doesn't change on
the Pivot chart. it still shows as 7/31/08. How can I change this I think
I'm choosing the right thing but since it hasn't changed I guess I'm not
HELP!!!!!!

 

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

 

[Cher062]

THANK YOU THANK YOU THANK YOU!!!

I knew there was a way but I just couldn't remember how to get to it. I
can't thank you enough.

 

[Greg McCarter]

I have had this same problem. In some of my pivot tables, there is NO
NUMBER format button under field settings.

Why would this happen?

 

[Debra Dalgleish]

If the field has blank cells or cells with text, you might not be able
to format the numbers, because that field is treated as Text data type.

 

[Greg McCarter]

Aha, that explains what is going on. I have some conditional IF s in there
that set the value to "" if other cells are blank. I think I can fix by
replacing "" with 0.

Thanks!!