The pivot table has the format I want to go in the chart. All of the source data is a full date but they are all month end dates, 6/30/2020, 7/31/2020, etc. The date on the axis is cumbersome and needs to be shorter. I have tried setting the date format for the access in the chart and it doesn't do anything.
Thoughts?
Thoughts?