Pivot Table question

[jbanas]

I have a field in excel that is a date i.e. (10/20/2007). I have formated the cell in table to show OCT-20. When i create a pivot chart from this table it shows the mm/dd/yyyy. Is there a way to exclude the YYYY from the chart so it just shows OCT-20. any help would be great, thanks

 

[SkipVought]

Hi,

Dates are just NUMBERS -- faq68-5827

Format the Date Field in the PT as you wish.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}