Dynamic Pie Chart legend based on hierarchy selection

I have a hierarchy for a company (i.e. Department -> Section -> Workgroup) with 2 drop down lists on the page - one for Department and one for Section.  When a user selects a Department the Sections ...