How change value in a chart using dropdown menu

Hi There, I have a list of data in a tab and I have brought forward the list of data I need to form a couple of graphs. I'm looking for a way to change the data thrught the use of dropdown menu to change what the graph represents. E.g graph 1 will show Section 1's Indsutry 1, graph 2 will show Section 1's Industry 2 and so on. But If I changed the dropdown for the graph to show Section 9 information, the graph should update accordingly. I have Pivot Charts, but that doesn't seem to work in my favour. The actual data I have doesnt have even number of Industries per Section, some Sections have 4 Industries, some have 6.

I have attacned an example sheet for reference

Any help will be much obliged.

KR
F