Freezing of form control(Combo Box) + Dynamic updating of the chart

Problem Statement:
- I have a combo box form control in xl sheet picking the value from database from the sheet which is hidden. The issue i am facing is that when i pick the value from combo box the whole combo box control is moving ..instead of only the values in combo box control.

- I have a chart picking the value from certain column range and displaying the same in other sheet. Do we have other approach for dynamic updation of chart instead of defining static range in xl as code source.


Hope you understand the problem statement and provide with better approach to both the problems.

Thanks!!​