Pivot Charts

  • Thread starter Thread starter Cher062
  • Start date Start date
C

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!!!!!!
 
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.
 
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.
 
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?
 
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.
 
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!!
 
Back
Top