Export (0) Print
Expand All
Expand Minimize

2.4.9 AxcExt

Office

The AxcExt record specifies additional extension properties of a date axis (section 2.2.3.6), along with a CatSerRange record (section 2.4.39).


0

1

2

3

4

5

6

7

8

9
1
0

1

2

3

4

5

6

7

8

9
2
0

1

2

3

4

5

6

7

8

9
3
0

1

catMin

catMax

catMajor

duMajor

catMinor

duMinor

duBase

catCrossDate

A

B

C

D

E

F

G

H

reserved

catMin (2 bytes): An unsigned integer that specifies the minimum date, as a date in the date system specified by the Date1904 record (section 2.4.77), in the units defined by duBase. SHOULD<25> be less than or equal to catMax. If fAutoMin is set to 1, MUST be ignored. If fDateAxis is set to 0, MUST be ignored.

catMax (2 bytes): An unsigned integer that specifies the maximum date, as a date in the date system specified by the Date1904 record (section 2.4.77), in the units defined by duBase. SHOULD<26> be greater than or equal to catMin. If fAutoMax is set to 1, MUST be ignored. If fDateAxis is set to 0, MUST be ignored.

catMajor (2 bytes): An unsigned integer that specifies the interval at which the major tick marks are displayed on the axis (section 2.2.3.6), in the unit defined by duMajor. MUST be greater than or equal to catMinor when duMajor is equal to duMinor. If fAutoMajor is set to 1, MUST be ignored. If fDateAxis is set to 0, MUST be ignored.

duMajor (2 bytes): A DateUnit enumeration (section 2.5.66) that specifies the unit of time to use for catMajor when the axis (section 2.2.3.6) is a date axis (section 2.2.3.6). If fDateAxis is set to 0, MUST be ignored.

catMinor (2 bytes): An unsigned integer that specifies the interval at which the minor tick marks are displayed on the axis (section 2.2.3.6), in a unit defined by duMinor. MUST be less than or equal to catMajor when duMajor is equal to duMinor. If fAutoMinor is set to 1, MUST be ignored. If fDateAxis is set to 0, MUST be ignored.

duMinor (2 bytes): A DateUnit enumeration (section 2.5.66) that specifies the unit of time to use for catMinor when the axis (section 2.2.3.6) is a date axis (section 2.2.3.6). If fDateAxis is set to 0, MUST be ignored.

duBase (2 bytes): A DateUnit enumeration (section 2.5.66) that specifies the smallest unit of time used by the axis (section 2.2.3.6). If fAutoBase is set to 1, this field MUST be ignored. If fDateAxis is set to 0, MUST be ignored.

catCrossDate (2 bytes): An unsigned integer that specifies at which date, as a date in the date system specified by the Date1904 record (section 2.4.77), in the units defined by duBase, the value axis (section 2.2.3.6) crosses this axis (section 2.2.3.6). If fDateAxis is set to 0, MUST be ignored. If fAutoCross is set to 1, MUST be ignored.

A - fAutoMin (1 bit): A bit that specifies whether catMin is calculated automatically. If fDateAxis is set to 0, MUST be ignored. MUST be a value from the following table:

Value

Meaning

0

The value specified by catMin is used and catMin is not calculated automatically.

1

catMin is calculated such that the minimum data points (section 2.2.3.10) value can be displayed.

B - fAutoMax (1 bit): A bit that specifies whether catMax is calculated automatically. If fDateAxis is set to 0, then fAutoMax MUST be ignored. If the value of the fMaxCross field in the CatSerRange (section 2.4.39) record is 1, then fAutoMax MUST be ignored. MUST be a value from the following table:

Value

Meaning

0

The value specified by catMax is used and catMax is not calculated automatically.

1

catMax is calculated such that the minimum data points (section 2.2.3.10) value can be displayed.

C - fAutoMajor (1 bit): A bit that specifies whether catMajor is calculated automatically. If fDateAxis is set to 0, MUST be ignored.

Value

Meaning

0

The value specified by catMajor is used and catMajor is not calculated automatically.

1

catMajor is calculated automatically.

D - fAutoMinor (1 bit): A bit that specifies whether catMinor is calculated automatically. If fDateAxis is set to 0, MUST be ignored.

Value

Meaning

0

The value specified by catMinor is used and catMinor is not calculated automatically.

1

catMinor is calculated automatically.

E - fDateAxis (1 bit): A bit that specifies whether the axis (section 2.2.3.6) is a date axis (section 2.2.3.6). MUST be a value from the following table:

Value

Meaning

0

The axis (section 2.2.3.6) is not a date axis (section 2.2.3.6).

1

The axis (section 2.2.3.6) is a date axis (section 2.2.3.6).

F - fAutoBase (1 bit): A bit that specifies whether the units of the date axis (section 2.2.3.6) are chosen automatically. If fDateAxis is set to 0, MUST be ignored. MUST be a value from the following table:

Value

Meaning

0

The value specified by duBase is used and duBase is not computed automatically.

1

duBase is calculated automatically.

G - fAutoCross (1 bit): A bit that specifies whether catCrossDate is calculated automatically. MUST be a value from the following table:

Value

Meaning

0

The value specified by catCrossDate is used and catCrossDate is not calculated automatically.

1

catCrossDate is calculated automatically such that it can be displayed.

H - fAutoDate (1 bit): A bit that specifies whether the axis (section 2.2.3.6) type is detected automatically. MUST be a value from the following table:

Value

Meaning

0

The axis (section 2.2.3.6) will stay as specified by the fDateAxis field.

1

The axis (section 2.2.3.6) will automatically become a date axis (section 2.2.3.6) when the data it is related to contains date values. Otherwise, the axis (section 2.2.3.6) will be a category (3)axis (section 2.2.3.6).

reserved (8 bits): MUST be zero, and MUST be ignored.

Show:
© 2014 Microsoft