How to automatically adjust the input data size of the graph to the amount of data?

Question

excel

There are a number of charts. And there are large datasets that are completely new several times a day, with a new number of rows.

I insert these tables and want the graphs to reflect them to me.

But there is a problem - due to the fact that each new data set has a different number of rows, which sometimes differs by orders of magnitude, you constantly have to manually enter the size of the input data. And since there are a lot of graphs, then doing it is long and tedious. Are there any ways to make the chart itself understand what size the data is and adjust the size of the input data accordingly?

Excel 2010, but if later ones have such functionality, then it is ready to migrate.