vba图表系列动态轴多系列

I have a chart that draws in data from fixed ranges on multiple sheets. I would like the axis on these charts to automatically fit to the ranges, and to be focussed in on the meaningful range, rather than from zero.I have a chart that draws in data from fixed ra