Automatic change in axis scale

Hello Excelforum members,

I'm a beginner to VBA and was hoping to get assistance on how to change the Y-axis when values change. In the attached file, if I change cell C28, the graph automatically changes. But, using VBA, how do I change the Y-axis? For example, when I change the dropdown to Team C, I would like the Y-axis to start at 40, rather than zero.

Any help would be greatly appreciated.
Thank you!