Can Pivot charts show dates in MMM format (excel 2003)

'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,

Try not to double post.

"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
Excel pivot table, numbers are reverting to dates format	John F	Microsoft Excel Misc	0	9th Dec 2009 02:25 PM
Can pivot charts show MMM formatted dates	Mally	Microsoft Excel Misc	1	25th Nov 2008 06:53 AM
Can't group by dates in Excel 2003 pivot table	=?Utf-8?B?YmFyYmFyYTEyMzQ=?=	Microsoft Excel Misc	5	15th Mar 2005 05:13 AM
Can links between Excel 2003 Pivot Charts and their pivot table b.	=?Utf-8?B?TWFyayBBbGxlbg==?=	Microsoft Excel Charting	2	5th Mar 2005 05:24 PM
Excel 2003 changes format of earlier charts	=?Utf-8?B?RGFuaWVsbGU=?=	Microsoft Excel Charting	0	20th Sep 2004 09:29 PM