Question: how to change the date format in excel 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.