CATSERRANGE: Defines a Category or Series Axis (1020h)

This record defines the scaling options for a category or series axis.

Record Data

Offset

Name

Size

Contents

4

catCross

2

Value axis/category crossing point (2-D charts only)

6

catLabel

2

Frequency of labels

8

catMark

2

Frequency of tick marks

10

grbit

2

Format flags


The catCross field defines the point on the category axis where the value axis crosses. A value of 01 indicates that the value axis crosses to the left, or in the center, of the first category (depending on the value of bit 0 of the grbit field); a value of 02 indicates that the value axis crosses to the left or center of the second category, and so on. Bit 2 of the grbit field overrides the value of catCross when set to 1.

The catLabel field defines how often labels appear along the category or series axis. A value of 01 indicates that a category label will appear with each category, a value of 02 means a label appears every other category, and so on.

The catMark field defines how often tick marks appear along the category or series axis. A value of 01 indicates that a tick mark will appear between each category or series; a value of 02 means a label appears between every other category or series, etc.

The grbit field contains the following option flags.

Offset

Bits

Mask

Name

Contents

0

0

01h

fBetween

Value axis crossing
0 = axis crosses midcategory
1 = axis crosses between categories

0

1

02h

fMaxCross

Value axis crosses at the far right
category (in a line, bar, column, scatter, or area chart; 2-D charts only)

0

2

04h

fReverse

Display categories in reverse order

0

7 – 3

F8h

(reserved)

Reserved; must be zero

1

7 – 0

FFh

(reserved)

Reserved; must be zero