Hello Friends,

Could you please kindly refer the attached spreadsheet and help me design a Pie Chart and an adjoining table ?

-A Drop down menu which has list of SALESMAN Names above the Graph
-When I select the SALESMAN names the pie chart automatically updates
-Pie Chart should show how much % each SALESMAN spent on each JOB
-If possible when I click/point on each JOB segment of Pie Chart, to show % breakdown by CUSTOMER
-I am using Excel 2003


Thanks Heaps.

Excel Dumbo