Page tree
Skip to end of metadata
Go to start of metadata

Description

Sets or returns the minimum value on the y axis.
C#
vb.net

Remarks

When creating new charts, or reading in charts where this value is not set, this property will return 0, which represent that this property does not contain a value and Excel will automatically determine an appropriate minimum for your value axis. Unfortunately, there is no way to distinguish between this state and when the MinValue property is actually set to zero.

This property can be set to more than the ValueAxis.MaxValue, although that is an illegal state. We allow this so that the order of operations does not matter when setting both the MinValue and MaxValue to different values. However, if the MinValue is still greater than the MaxValue when you try to save, the MaxValue will be treated as the MinValue and vice versa so that the resulting file is not corrupt.

If ValueAxis.UseLogarithmicScale is turned on, then this property represent the power of the minimum value in base 10 (or whatever base you've manually set). For instance, if this value is set to 2. Then with UseLogarithmicScale turned off, the resulting file will have a minimum value of 2. If UseLogarithmicScale is turned on, then the resulting file will have a minimum value of 100 (10 2).

  • No labels