Dropdown list in Graph

[DEL41]

I have a graph with budget sales against actual sales over number of months and would like to put in a dropdown to show sales for each customer.
Can I put a dropdown list in graph so that end user can select a particular customer to view monthly sales ( act v Bud).
I am happy using dropdown lists in excel but am having trouble getting a dropdown list on to graph for end user

 

[Steve=True]

Hi Del41,

Here are a few tutorials to help you out:

Change Chart from Amount to Percent using a Drop Down List

How-to Create Dynamic Excel Dashboards Using Picklists

How-to Make a Picklist Change the Chart Type for a Dynamic Excel Dashboard



Let me know if they help.

Steve=True