How change value in a chart using dropdown menu

Let me rephrase the requirement to see if I understand it correctly. You would like to use a drop down list to select a section. Based on the selection of a section, you would like to select an industry from another drop down list. So if you selected Section 1 and Section 1 had 5 industries, the second dropdown list will show only these 5 industries. Then you want to chart Close, Purpose and Interact as a column chart, I suppose?

Did you mean, your "data" sheet is a original data bank & you want result as per "graph data" sheet. plz confirm.
If above point is corrected then you use index match formula.

I am using the technique described in this article to do the cascading dropdown list. http://www.utteraccess.com/wiki/inde..._%28Non-VBA%29.

On sheet 1, the pivot tables are used to run the dropdown lists. Select the section in cell G3 and it will limit the list you see in cell G6.

I also make use of what I call a composite index. What makes a record unique in the data table is the combination of Section, Industry and Item (Close, Propose and Interact). I use MATCH to find the matching composite and INDEX to look up the associated value.

Can you mock up what the desired output looks like? thanks.

refer attach file.

Originally Posted by FrancisM2411

Thanks Avk, this is good. One other question off topic, i had with regards to graphs, I've come across a line graph where it has a numbr of lines and all are grayed out. there is a dropdown and when they selet a heading, one of the lines changes colour whist the other lines remain gray. Wuld you happend to know how I can achieve that format on a graph? thanks

Dear Fancis, this is another issue. plz post thread separatly.
Secondly, If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".