axis automatic range and grid line increments

[JStirfry]

Hello,

Does anyone know the formulas excel uses to develop and show an axis range, major grid lines, minor grid lines, and increments when graphing charts? Not sure if it matters, but I'm specifically trying to figure this our for a scatter chart type.

Thanks in advance!

 

[thisoldman]

Try "How Excel Calculates Automatic Chart Axis Limits" by Jon Peltier, https://peltiertech.com/how-excel-calculates-automatic-chart-axis-limits/.