Pie Chart and Table Query

[Ecel Dumbo]

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

 

[NARAYANK991]

Hi ,

I have posted a link , which I came across recently , in the Dashboards section of this forum ; I think that can help. The link is :

http://datapigtechnologies.com/blog...hboard-interfaces-with-shape-layering-tricks/

Narayan

 

[Ecel Dumbo]

THanks Narayan This is really helpful