G Guest Mar 23, 2006 #1 When using the automatic scale for graphs sometimes it defaults to zero even when the data spread is fairly narrow - why ?
When using the automatic scale for graphs sometimes it defaults to zero even when the data spread is fairly narrow - why ?
J Jon Peltier Mar 23, 2006 #2 This is just how Excel calculates the minimum and maximum scale. They have an article about this, which explains how it calculates the min and max, but not the major unit. http://support.microsoft.com/?kbid=214075 - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______
This is just how Excel calculates the minimum and maximum scale. They have an article about this, which explains how it calculates the min and max, but not the major unit. http://support.microsoft.com/?kbid=214075 - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______
