Forum Discussion
Solved
changing Date format in a pivot table
Hello, Could you please help me .... I can't change the date format in the pivot chart, I want it to like: 6-Jan-2018 ....please find the file attached Thanks
In the attached file, all I did was:
- Right-click cell A4 and choose "Field Settings"
- Click the Number Format button
- Choose Date category and select "March 14, 2012"
- OK your way out.
Normally the chart should follow the date format as set in the source data.
thanks,
As you see the source data is a pivot table on the left of the pivot_chart
I ungrouped the tabled but didn't work!
- In retrospect:
- rightclick the pivottable field with the date, select "Field settings". Click the Number format button and change the display format to the date format you like.thanks,
I tried ... it's not working
I've attached the file in case you want to have a look on it
In the attached file, all I did was:
- Right-click cell A4 and choose "Field Settings"
- Click the Number Format button
- Choose Date category and select "March 14, 2012"
- OK your way out.
- I see, I can't convince Excel to display the dates differently either. Probably some silly limitation of a pivot chart. Anything I set for the chart axes number format or any date formatting I apply to the pivottable or its source data is completely ignored. Sounds like a bug to me.