Can pivot charts show MMM formatted dates

's Computer Specifications

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 Computer Specifications

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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PIVOT TABLE - Show Dates in months	Dave Eade	Microsoft Excel Discussion	3	10th Mar 2010 04:52 PM
Can Pivot charts show dates in MMM format (excel 2003)	Mally	Microsoft Excel Misc	1	25th Nov 2008 06:55 AM
show results of two pivot charts	=?Utf-8?B?am9obmptY2Rlcm1vdHQ=?=	Microsoft Excel Charting	3	6th Mar 2006 12:47 PM
Sorting Pivot Charts By Dates	Paul Brown	Microsoft Access Queries	0	19th Jul 2004 09:19 AM
Re: Show all dates in Pivot Chart?	Douglas J. Steele	Microsoft Access	0	24th Jun 2004 05:41 PM