The Office Scripts action recorder can generate code snippets for Excel changes, but some actions still require manual ...

If you need a legend longer than your data, you’ve gone too far.

Excel isn't hard, just learn the right tricks early enough.