Excel Charting

[NYEXCEL1]

I am trying to create a chart but i do not seem to be getting the result i am looking for. With the data below a client's name may show up multiple time in a data table with different periods listed. I am trying to get all data by client with the period on the horizontal axis and overservice on one hortizontal axis and revenue on the other horizontal axis. Ideally, i could pick the customer name from a dropdown menu and all the data related would populate the chart. Any help would be welcome?

Customer Name	Hours	Time Cost )	Fiscal Period	Net Revenue	Overservice
Client A	342.75	$ 46,038.75	201203	$ 18,303.86	151.5%
Client A	240.25	$ 31,006.25	201204	$ 19,154.34	61.9%
Client B	234	$ 42,125.00	201206	$ 28,759.63	46.5%
Client B	190.75	$ 34,568.75	201207	$ 19,000.00	81.9%
Client C	341.25	$ 56,156.25	201208	$ 19,641.73	185.9%

<tbody>
</tbody><colgroup><col><col><col><col><col><col></colgroup>

 

[p45cal]

like this downloadable file? Dropdown in A1
<embed src="https://www.box.com/embed/2stji9tqdjaz12h.swf" wmode="opaque" type="application/x-shockwave-flash" allowfullscreen="true" allowscriptaccess="always" height="400" width="466">

 

[NYEXCEL1]

I took a look and we are heading in the right direction. that table is in a pivot table and when i am creating the chart i wanted the title of the chart to reflect the client i am choosing. the pivot charts have buttons but the name of the client does not appear when you make the selection. any way to make the title reflect that choice?

 

[p45cal]

So the chart is a pivot chart? That's usually good news, as we can usually put the Client in the page field and have it appear as a drop down on the chart. Can you post the workbook or a version of it somewhere?

 

[NYEXCEL1]

Given the nature of the information i cannot post. I have customer name as a field and currently i have located in the report filter area on the pivot table list. I dont see any options to create a drop down menu from this field. can you tell me how to do that?

 

[p45cal]

Can't you post a cut-down version, search and replace the sensitive stuff with meaningless data, reduce the amount of data, and delete any non-relevant sheets/data?
It's awfully hard to guess at what you've got, and if I get it wrong it's useless to you.
If you really don't want it in the public domain, but you're happy just for me to look at any kind of version, Private Message me here for an email address that you can send it to.