LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Senior Member
 
Posts: 105
Default Pie Chart and Table Query

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
Attached Files
File Type: zip Graph Query.zip (8.4 KB, 54 views)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Web Query and table? Donal McWeeney Excel Programming 8 May 23rd 07 10:32 AM
Resizing chart because of refreshing Chart Data through a query jayb Charts and Charting in Excel 0 August 10th 06 04:21 PM
VB way to remove the query from a Query Table? Toby Erkson[_3_] Excel Programming 4 October 29th 04 03:16 PM
Linking a table in Access to a table in Excel using MS Query Diana[_5_] Excel Programming 1 January 16th 04 09:43 PM
Chart & ms Query issue michanne Excel Programming 0 November 5th 03 06:55 PM


All times are GMT +1. The time now is 09:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"