Plot by child level in selected hierarchy

Hi folks!  I am trying to build a dashboard for executives that allows a person to drill through a hierarchy and automatically plots or displays data according to the next level down in the hierarchy...