Question: how to change date format in excel pivot chart?
Answer: Right-click a date in the pivot table (not the pivot chart).
Click on Field Settings.
Change the Number Format to the date format that you want.