Export (0) Print
Expand All
Expand Minimize

2.4.327 Tick

Office

The Tick record specifies the attributes of the axis labels, major tick marks, and minor tick marks associated with an 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

tktMajor

tktMinor

tlt

wBkgMode

rgb

reserved1

reserved2

reserved3

reserved4

A

B

rot

C

unused

D

icv

trot

tktMajor (1 byte): An unsigned integer that specifies the location of major tick marks. MUST be a value from the following table:

Value

Tick mark location

0x0000

None. No major tick marks are drawn on the axis.

0x0001

Inside. Major tick marks are drawn toward the plot area.

0x0002

Outside. Major tick marks are drawn away from the plot area.

0x0003

Crossing. Major tick marks are drawn evenly on both sides of the axis.

tktMinor (1 byte): An unsigned integer that specifies the location of minor tick marks. MUST be a value from the following table:

Value

Tick mark location

0x0000

None. No minor tick marks are present on the axis.

0x0001

Inside. Minor tick marks are drawn toward the plot area.

0x0002

Outside. Minor tick marks are drawn away from the plot area.

0x0003

Crossing. Minor tick marks are drawn evenly on both sides of the axis.

tlt (1 byte): An unsigned integer that specifies the location of axis labels. MUST be a value from the following table:

Value

Tick mark label location

0x0000

None. No axis labels are present on the axis.

0x0001

Low. Axis labels are drawn to the left of the plot area for a vertical axis or below the plot area for a horizontal axis for all chart group types except radar. Axis labels for radar chart group types will be drawn as if the value was 0x0003.

0x0002

High. Axis labels are drawn to the right of the plot area for a vertical axis or above the plot area for a horizontal axis for all chart group types except radar. Axis labels for radar chart group types will be drawn as if the value was 0x0003.

0x0003

Next to Axis. Axis labels are drawn next to the axis.

wBkgMode (1 byte): An unsigned integer that specifies the display mode of the background of the text of the axis labels. MUST be ignored if the value of fAutoCo is 1. MUST be a value from the following table:

Value

Background Mode

0x0001

Transparent background

0x0002

Opaque background. The background color will match the rgbBack field in the associated AreaFormat record as specified by the AXS rule in the Chart Sheet Substream ABNF.

rgb (4 bytes): A LongRGB structure that specifies the color of the text for the axis labels. MUST be ignored if fAutoCo is 1.

reserved1 (4 bytes): MUST be zero, and MUST be ignored.

reserved2 (4 bytes): MUST be zero, and MUST be ignored.

reserved3 (4 bytes): MUST be zero, and MUST be ignored.

reserved4 (4 bytes): MUST be zero, and MUST be ignored.

A - fAutoCo (1 bit): A bit that specifies if the foreground text color of the axis labels is determined automatically.

Value

Meaning

0

The text uses the color specified by rgb.

1

The text uses an automatically selected foreground color, based on the computer’s display settings.

.

B - fAutoMode (1 bit): A bit that specifies if the background color of the axis label is determined automatically.

Value

Meaning

0

The background color is specified by wBkgMode.

1

The background color is set according to the DefaultText settings of the chart.

.

rot (3 bits): An unsigned integer that specifies text rotation of the axis labels. MUST be a value from the following table:

Value

Text Rotation

0x0

Text is drawn with the rotation specified by the value of trot.

0x1

Text is drawn stacked, top-to-bottom, with the letters upright.

0x2

Text is drawn rotated at 90 degrees counterclockwise.

0x3

Text is drawn rotated at 90 degrees clockwise.

C - fAutoRot (1 bit): A bit that specifies whether the text rotation of the axis label is determined automatically.

Value

Meaning

0

The axis labels do not rotate automatically, and follow the rotation specified by rot and trot.

1

The axis labels rotate as the location of the axis changes and the value of the rot and trot fields MUST be ignored.

.

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

D - iReadingOrder (2 bits): An unsigned integer that specifies the reading order of the axis labels. MUST be a value from the following table:

Value

Meaning

0x0

The reading order is equal to the iReadingOrder value of the Text record immediately following the closest preceding Chart, DataFormat, Legend, Series or YMult record where iReadingOrder is not equal to 0x0. If no such preceding record exists, the DefaultText settings of the chart is used. If the DefaultText settings also specify 0x0, the reading order is determined by the Application.

0x1

Left-to-right

0x2

Right-to-left

icv (2 bytes): An Icv that specifies the color of the text. The color MUST be the same as rgb.

trot (2 bytes): An unsigned integer that specifies the axis label’s text rotation. MUST be a value from the following table:

Value

Meaning

0 to 90

Text rotated 0 to 90 degrees counterclockwise

91 to 180

Text rotated 1 to 90 degrees clockwise (angle is trot – 90)

255

Text top-to-bottom with letters upright

Show:
© 2014 Microsoft