在更改数据时自动更新VBA代码

I am attempting to use VBA to set chart axis parameters based on data. This is for work and I am going to lock the spreadsheet as a template so others can fill in data but the chart will be made for them. Depending on the test they are running, the axes may need to be different. I have a code for this that works perfect, but it doesn't update automatically when data changes, I have to refresh it manually. Here is the code:I am attempting to use VBA to set chart axis pa