Dynamic chart with Drop Down List

Hi Guys

I'm trying to create a dynamic chart with a drop down list with no hope!!!

Please could someone assist?

So basically, i need to select from a drop down list a team which in turn will populate a line graph.

I have attached a workbook.

Also, the target across the months is 95% which needs to be shown as well.

Hello,

Attached is a workbook that I believe achieves the results you requested. The workbook now contains macros so you'll need to enable macros and/or content when you open the workbook.

To watch it work select a team from the H2 dropdown.

To view the code press F11 while holding down the Alt key to open Visual Basic. I have inserted comments into the code so that you may adjust it if needed.

Please let me know if you have any questions.



Thanks!

RVASQUEZ