Tree structure data visualization

Looking for breakdown tree? Here it is!


Green arrow – show/hide children

Orange arrow – hide 3 siblings

Purple arrow – show 3 more siblings


Show measure – hiding values and bars (tooltip is still available)

Children limit – default amount of children visible after showing next level


Category – upper here means upper in tree

Measure – items are sorted by first record; all measures are visible in tooltip

Add-in capabilities

When this add-in is used, it

  • Can read and make changes to your document
  • Can send data over the Internet