Hello,

I have the following data in Excel (see attached file).

I am looking to create a bar graph (sorted from largest to smallest) which can be filtered by "business unit", "Team" and "Sub-team". I only require a summary view, not the individual employee scores. I want the graph to automatically update and sort (largest to smallest) when a filter is selected (want to avoid the use of macros). I am thinking a pivot table would be best.

Can someone please help me out with this.

Thanks!