How to ensure that chart size (length and width) adjust automatically?

Greetings All,

I need a small favour. Could anyone please advise of a way by way of which charts in an excel sheet automatically adjust their size (length and width) based on data size.

I googled and found 2 ways it can be done; i.e. through Name Data Ranges and VBA, but neither fits my requirement. I can't use the former as it increases my file size considerably and in case of latter have limited experience plus it does not suit the intent.

Is there an alternate way? Any links / samples that anyone could share? I'll be obliged.

Do let me know if any additional info is needed.

Thanks!

Could anyone please provide some suggestions on this please...

Thanks,

Spi