Dynamic Name range for charts

Morning from ATL!

I am creating a column chart with a dynamic range that only plots active data and lists active axis values in the legend.

Column B (Name) has names of employees under a specific team. When team changes, so does Column B list.

I attempted to create a defined name range and table using offset but royally failed. Without defined name range I get a bunch of blanks (B10 thru B20) which ends up in my plotting field and legend. Any solution to this?

Note: Months never change. Also for Target I used a line chart which sets a target line across the chart.