Can pivot charts show MMM formatted dates
 

Hi

I have formatted my pivot table dates in custom MMM format i.e. May, but
they still show as a complete date in the pivot chart e.g. 01/06/2008.

Is there any way of displaying the MMM format in the chart?

Can pivot charts show MMM formatted dates
 

Hi,

Works fine on my machine. What version of Excel are you using and where are
the date displayed - on the axis, as data labels or what?

Cheers,
Shane Devenshire

"Mally" wrote:

Hi

I have formatted my pivot table dates in custom MMM format i.e. May, but
they still show as a complete date in the pivot chart e.g. 01/06/2008.

Is there any way of displaying the MMM format in the chart?