Happy St. Patrick's Day Friends,

I need help. In the attached sample workbook, I need to find a solution to two issues.

#1) I need to be able to sort, biggest to smallest, for the values in cells I:2, I;6 , I:10, etc... The solution would keep the four rows for Fred, John, Frank, etc.. together. I am aware Excel is not the best tool for this sort of reporting but this is ad-hoc until a formal (Java) solution can be developed.

and #2) I need to be able to graph each "Salesperson" in the most efficient way possible. The solution would help me create graphs efficiently upfront and then possibly use a drop down and VBA to display only the graph selected.

Thank you and Karma for all!

Chris

Test.xlsx