Log In
Register
Home
Changing pivot chart axes.
uber setis
New Member
Members
Forum Posts: 1
Member Since:
November 20, 2020
November 20, 2020
Offline1
November 20, 2020 - 4:55 pm
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.
Catalin Bombea
Iasi, Romania
Member
Dashboards
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
Forum Posts: 1939
Member Since:
November 8, 2013
November 8, 2013
Offline2
November 23, 2020 - 12:23 am
Can you please provide a sample file with the chart you mentioned?
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Kevin Campbell
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1939
SunnyKow: 1432
Anders Sehlstedt: 930
Purfleet: 415
Hans Hallebeek: 355
Frans Visser: 349
David_Ng: 312
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
iDeYYtyNRPTss icXlxLtkCZaWuY
Elizabeth Kinsey
Shaun Del Toro
Clive Webb
Forum Stats:
Groups: 3
Forums: 25
Topics: 7095
Posts: 31110
Member Stats:
Guest Posters: 49
Members: 34529
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —