Could anyone kindly advise how to keep my sample chart unchanged after deleting the unnecessary Row 2?
I have a Google Sheet that contains over 50 charts whose data source is within only one big data table. Now I need to delete several useless rows which are not used for creating those charts. However, every time I delete a row, the series get changed and all my charts get changed as well. I would greatly appreciate any solutions or tips.
Link to my Sample Chart [Anyone can edit]: https://docs.google.com/spreadsheets/d/1jMhL2MnMvUJ82igS5RHQpUYQbIRVtjpU37n6SpEVp4o/edit?usp=sharing
Sample Chart before Deleting Row 2
The data range is A1:J100.
Sample Chart after Deleting Row 2
The data range is automatically changed to A1:J99.