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.