Make Excel Charts Dynamic using Named Ranges

Hello Excel Experts...
I need a small help to add my named ranges into charts to make them dynamic based on the values we choose from drop down..Attached the file i am working on.

What i have done until now:
1) Created dependent drop down list in "Charts" sheet (Range B3 and Range D3) based on the table available in "Data" sheet.
2) Created Named ranges to reference the table dynamically based on name chosen from D3 cell.
These Named Ranges are as below
- Codes : It refers to the table data below the Name
- dataRange : It refers to the table data below the Months
- EntireTable : It refers to the entire table data for name chosen at cell D3.

What i need help on:
I want to add these named ranges into the chart shown in "Charts" sheet to make it dynamic based on Name chosen using drop down at cell D3.
When i add 'EntireTable' named range, excel crashes and i struggling to use 'Codes' and 'dataRange' named ranges into this chart.

Please help me out.

Thanks in advance.

Yes please, but in that case you need change Names Ranges as well..I know it will be tedious job for you..Thanks for your help.

It wont affect actually... Instead of providing one single drop down with long list,i made a split based on category..My only concern is the uneven heights of table, thats what makes it bit challenging i believe...

Hey popipipo, thats what i was looking for...I am studying your template right now...Big thanks for your help...

Hello Popipipo , can you help me with below post please..? It is just the continuation of your solution..

https://www.excelforum.com/excel-pro...ic-charts.html