| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Pivot charts show dates in MMM format (excel 2003) | Excel Discussion (Misc queries) | |||
| Formula using formatted dates | Excel Discussion (Misc queries) | |||
| Formatted row pattern doesn't show in preview or print | Excel Discussion (Misc queries) | |||
| Pivot Table - only show dates greater than =today() | Excel Discussion (Misc queries) | |||
| show results of two pivot charts | Charts and Charting in Excel | |||
Linear Mode
