Mar 04 2019 12:22 AM - edited Mar 04 2019 05:57 AM
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
Mar 04 2019 01:37 AM
Mar 04 2019 01:41 AM
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!
Mar 04 2019 05:39 AM
Mar 04 2019 05:42 AM
Mar 04 2019 05:55 AM
thanks,
I tried ... it's not working
I've attached the file in case you want to have a look on it
Mar 04 2019 07:48 AM
SolutionIn 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.
Mar 04 2019 08:29 AM
Thank you so much ... it's a bit Embarrassing for me .... I don't know why it wasn't working for me
Mar 04 2019 08:30 AM
Mar 04 2019 08:31 AM
Jan 05 2020 03:00 AM
@Jan Karel PieterseI have a pivot table and chart in (current) Office 365 with dates in the row column; when I follow the same steps as described below, there is no "Number Format" button showing in the Field Settings dialog - see screen copy below. Why is that?
I managed to change the date format within the pivot table (using "ungroup"), but this new format does not get reflected in the Pivot Chart. How can I solve this?
Jan 05 2020 12:50 PM
@iveccc as far as I am aware of there is no Number Format option for fields in the Row or Filter section. You can only set the formats for the fields in the Column or Values section.
Have you tried to re-organize your data in the way to have Dates field in Column section?
Also it would be good if you can attach your file - to check on you example.
Cheers,
Branka
Jan 05 2020 01:17 PM
Oct 04 2020 08:34 PM
@Sergei Baklan Can you explain more how do you do that?
Thanks
Oct 05 2020 08:09 AM
Sorry, I didn't catch what is the question about. How to create PivotTable with and without loading data to data model?
Oct 05 2020 08:15 PM
Hi, Yes. Would like understand more about these two differences.
By default if we create from table to pivottable, it will using non-data model?
I also notice that the date format can change if you set to ungroup the field. By default it is group it, then even you change the number format for change date format, it will not work
Oct 10 2020 10:56 AM
Oops, I don't remember that is default option for newly installed Excel. In general that is one which set here
Feb 01 2021 09:33 AM
I was having the same problem with dates, Ungrouping them worked
Oct 28 2021 09:23 AM
I am using desktop version Excel for Mac.
I can not find any way to change date format. There is no option for that neither in PivotTable field settings nor in excel option.
SOS
Oct 28 2021 01:42 PM
Sorry, I don't use Mac. @Riny_van_Eekelen , if you know.
Mar 04 2019 07:48 AM
SolutionIn 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.