I have a Pivot Chart (Excel 2016) that displays the instances of a range of dates.
It is displaying the X Axis label as "21-Mar", "22-Mar", etc.
I would like it to display as "Wednesday, March 21, 2016".
I have tried formatting the date in 'Axis Options' -> 'Format Code' as well as using 'Format Cells' in the 'Row Labels' column in the Pivot Chart sheet.
Neither of these changes the labels on the chart itself.