Excel Hierarchy

ReaazL

New Member
Joined
Mar 8, 2019
Messages
2
Hi

Please do kindly assist me, I would like to know if it is possible to use a single drill down and drill up function to update all the charts in my work book? if so please kindly guide me on how to get this done.
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

ReaazL

New Member
Joined
Mar 8, 2019
Messages
2
So you know in power pivots you are able to create hierarchy's in your data model and use them in pivot tables and charts. So lets say i have two charts reading from the same data and when i drill down or up on one chart i would like the other chart to update as well at the same time.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,161
Messages
5,527,156
Members
409,750
Latest member
BorisYeltsin

This Week's Hot Topics

Top