chart series data selection - automatic axis update

Welcome to the Forum!

Makes perfect sense but there is no fully automated way to do this built into Excel (that I know of).

The easiest thing is to hide the unused columns and rows, as in the attached modification to your file. This is manual.

An automated solution could be developed by writing some VBA that would effectively do the same thing.