VBA To Re-Scale Every Excel Graph's Y-Axis Bounds Based On Chart Data Points

VBA To Re-Scale Every Excel Graph's Y-Axis Bounds Based On Chart Data Points

This VBA macro code will cycle through every graph on the ActiveWorksheet and adjust the Y-axis bounds based on the Minimum and Maximum values found within the chart's data set. The VBA code also allows you to add some padding to the bounds, so the upper bounds of the chart doesn't equal the highest data point.

Read More