PC Review


Reply
Thread Tools Rate Thread

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

 
 
Mally
Guest
Posts: n/a
 
      24th Nov 2008
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?
 
Reply With Quote
 
 
 
 
Shane Devenshire
Guest
Posts: n/a
 
      25th Nov 2008
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?

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:29 PM.