peltiertech.com
Chart UDF to Control Axis Scale - Peltier Tech Blog
Can you really use a User Defined Function to control axis scales? There's a fortuitous bug/feature in Excel UDFs that makes it possible. This tutorial shows a chart UDF that controls a chart axis scale.