Can pivot charts show MMM formatted dates

M

Mally

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?
 
S

Shane Devenshire

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
 

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

Can Pivot charts show dates in MMM format (excel 2003) 1
dates on pivot table not right 4
Convert mm-dd-yy to mmm so pivot table reads mmm not mm-dd-yy 1
Please help....Date Format issue 1
VLOOKUP Dates in a Pivot Table 1
Date formatting problem 3
Pivot Table - cells imported as 'Blank' 2
How to show only Month of a mm/dd/yyyy format? 4

Top