Chart in Excell

1. Dear all,

i need your help please.
I my file you will se the vertical Axis, contains names of sales reps.

this chart change when we chane the cells e2 ( Name of business).

For Coro exc.RDn ( we have many reps , so the chart looks good.

But when i chose RDN, we have a few reps( New business), so the chart looks very big & bad.

How can i please make the chartt chage size automatiqely when we change value in Cell E2.

Thanks very much for your help