Searching for way to automatically change axis bounds on a group of charts

[kimplut]

Good afternoon
I have a workbook with four tabs, three of the tabs contain charts. I would like help to be able to automatically update the minimum and maximum on the axis as the data changes. All the charts start at 0 and it would make more sense for the minimum to start at a value closer to the lowest value in each chart.

Is there a way to automatically do this? I am not familiar with macros but am willing learn.

Thanks
Kim Plut