Pie Chart and Table Query

[Excel Dumbo]

Hello Friends,

Could you please kindly refer the attached spreadsheet and help m
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, t
show % breakdown by CUSTOMER
-I am using Excel 2003


Thanks Heaps.

Excel Dumb

+-------------------------------------------------------------------
|Filename: Graph Query.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=932
+-------------------------------------------------------------------

 

[Claus Busch]

Hi,

Am Mon, 2 Dec 2013 05:47:33 +0000 schrieb Excel Dumbo:

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

try it with a Pivot Chart. You can filter for salesmen in the Pivot
table and the chart will change.
Have a look:
https://skydrive.live.com/#cid=9378AAB6121822A3&id=9378AAB6121822A3!326
for "Graph Query"


Regards
Claus B.

 

[Excel Dumbo]

Thanks Claus. I am using Excel 2003. I will try using it. THanks fo
your tim

+-------------------------------------------------------------------
+-------------------------------------------------------------------