Export (0) Print
Expand All
Expand Minimize

2.4.341 ValueRange

Office

The ValueRange record specifies the properties of a value axis.


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

numMin

...

numMax

...

numMajor

...

numMinor

...

numCross

...

A

B

C

D

E

F

G

H

unused

numMin (8 bytes): An Xnum (section 2.5.342) structure that specifies the minimum value of the value axis. MUST be less than the value of numMax. If the value of fAutoMin is 1, this field MUST be ignored.

numMax (8 bytes): An Xnum structure that specifies the maximum value of the value axis. MUST be greater than the value of numMin. If the value of fAutoMax is 1, this field MUST be ignored.

numMajor (8 bytes): An Xnum structure that specifies the interval at which major tick marks and major gridlines are displayed. MUST be greater than or equal to the value of numMinor. If the value of fAutoMajor is 1, this field MUST be ignored.

numMinor (8 bytes): An Xnum structure that specifies the interval at which minor tick marks and minor gridlines are displayed. MUST be greater than or equal to zero. If the value of fAutoMinor is 1, this field MUST be ignored.

numCross (8 bytes): An Xnum structure that specifies at which value the other axes in the axis group cross this value axis. If the value of fAutoCross is 1, this field MUST be ignored.

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

Value

Meaning

0

The value specified by numMin is used as the minimum value of the value axis.

1

numMin is calculated such that the data point with the minimum value can be displayed in the plot area.

B - fAutoMax (1 bit): A bit that specifies whether numMax is calculated automatically. MUST be a value from the following table:

Value

Meaning

0

The value specified by numMax is used as the maximum value of the value axis.

1

numMax is calculated such that the data point with the maximum value can be displayed in the plot area.

C - fAutoMajor (1 bit): A bit that specifies whether numMajor is calculated automatically. MUST be a value from the following table:

Value

Meaning

0

The value specified by numMajor is used as the interval at which major tick marks and major gridlines are displayed.

1

numMajor is calculated automatically.

D - fAutoMinor (1 bit): A bit that specifies whether numMinor is calculated automatically. MUST be a value from the following table:

Value

Meaning

0

The value specified by numMinor is used as the interval at which minor tick marks and minor gridlines are displayed.

1

numMinor is calculated automatically.

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

Value

Meaning

0

The value specified by numCross is used as the point at which the other axes in the axis group cross this value axis.

1

numCross is calculated so that the crossing point is displayed in the plot area.

F - fLog (1 bit): A bit that specifies whether the value axis has a logarithmic scale. MUST be a value from the following table:

Value

Meaning

0

The scale of the value axis is linear.

1

The scale of the value axis is logarithmic. The default base of the logarithmic scale is 10, unless a CrtMlFrt record follows this record, specifying the base in a XmlTkLogBaseFrt structure.

G - fReversed (1 bit): A bit that specifies whether the values on the value axis are displayed in reverse order. MUST be a value from the following table:

Value

Meaning

0

Values are displayed from smallest-to-largest, from left-to-right, or from bottom-to-top, respectively, depending on the orientation of the axis.

1

The values are displayed in reverse order, meaning largest-to-smallest, from left-to-right, or from bottom-to-top, respectively.

H - fMaxCross (1 bit): A bit that specifies whether the other axes in the axis group cross this value axis at the maximum value. MUST be a value from the following table:

Value

Meaning

0

The other axes in the axis group cross this value axis at the value specified by numCross.

1

The other axes in the axis group cross the value axis at the maximum value. If fMaxCross is 1, then both fAutoCross and numCross MUST be ignored.

unused (8 bits): Undefined and MUST be ignored.

Show:
© 2014 Microsoft