Microsoft KB Archive/78663

{| = Excel: Logarithmic Scale Defaults Are Documented Incorrectly =
 * width="100%"|

Last reviewed: November 3, 1994

Article ID: Q78663

SUMMARY
The section labeled &quot;Logarithmic Scale&quot; on page 465 of the &quot;Microsoft Excel User's Guide&quot; for version 3.0 states:

If all data values are zero or less, the minimum is set to 0.1 and the maximum is set to 1. This is incorrect. Attempting to format the y-axis scale to logarithmic with such data values will return the following error message: Negative or zero values cannot be plotted correctly on log charts. This is because the log of values less than or equal to zero is undefined mathematically.