2.4.39 CatSerRange
The CatSerRange record specifies the properties of a category (2) axis, a date axis, or a series axis.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
catCross |
catLabel |
||||||||||||||||||||||||||||||
|
catMark |
A |
B |
C |
reserved |
|||||||||||||||||||||||||||
catCross (2 bytes): A signed integer that specifies where the value axis crosses this axis, based on the following table. If fMaxCross is set to 1, the value this field MUST be ignored.
-
Axis Type
catCross Range
Category (2) axis
This field specifies the category (2) at which the value axis crosses. For example, if this field is 2, the value axis crosses this axis at the second category (2) on this axis. MUST be greater than or equal to 1 and less than or equal to 31999.
Series axis
MUST be 0.
Date axis
catCross MUST be equal to the value given by the following formula:
-
catCross = catCrossDate – catMin + 1
Where catCrossDate is the catCrossDate field of the AxcExt record and catMin is the catMin field of the AxcExt record.
-
-
catLabel (2 bytes): A signed integer that specifies the interval between axis labels on this axis. MUST be greater than or equal to 1 and less than or equal to 31999. MUST be ignored for a date axis.
catMark (2 bytes): A signed integer that specifies the interval at which major tick marks and minor tick marks are displayed on the axis. Major tick marks and minor tick marks that would have been visible are hidden unless they are located at a multiple of this field. MUST be greater than or equal to 1, and less than or equal to 31999. MUST be ignored for a date axis.
A - fBetween (1 bit): A bit that specifies whether the value axis crosses this axis between major tick marks. MUST be a value from to following table:
-
Value
Meaning
0
The value axis crosses this axis on a major tick mark.
1
The value axis crosses this axis between major tick marks.
B - fMaxCross (1 bit): A bit that specifies whether the value axis crosses this axis at the last category (2), the last series, or the maximum date. MUST be a value from the following table:
-
Value
Meaning
0
The value axis crosses this axis at the value specified by catCross.
1
The value axis crosses this axis at the last category (2), the last series, or the maximum date.
C - fReverse (1 bit): A bit that specifies whether the axis is displayed in reverse order. MUST be a value from the following table:
-
Value
Meaning
0
The axis is displayed in order.
1
The axis is display in reverse order.
reserved (13 bits): MUST be zero, and MUST be ignored.