I have a pivot chart I created from my power pivot data model. I want to write a macro to change the axes from the “date” field to the “month” field on the calendar table. I’m having trouble assigning the axis object and figuring out which method to use to change this so the chart shows data by month instead of by date.