Chart in Excell

[ketats1]

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

[pike]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.