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


Sets or returns the number of categories to show between tick mark labels.



This property corresponds to the "Interval between labels" property under "Axis Options".

By default, this value is automatic. It will return 1 in this case. At this time, there is no way to distinguish between when this property is automatic, and when this property is set to 1. Nor is there a way to set this property back to automatic.

The minimum allowed value is 1. In Xlsx, the maximum allowed value is 999999999. But in Biff, the maximum allowed value is 31999. If you set this property to a value out of bounds, it will be clamped to the nearest allowed value.

When this property is set to 1, it will result in the property being set to automatic inside the resulting file.

This property has no effect when the category axis will be interpreted as a date axis.

  • No labels