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.