Excel Hierarchy

[ReaazL]

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.

 

[Gerald Higgins]

Hi, welcome to the board.

What do you mean by

...a single drill down and drill up function to update all the charts...

?

 

[ReaazL]

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.