POS: Position Information (104Fh)

This record defines manual position information for the main-axis plot area, legend, and attached text (data labels, axis labels, and chart title). The record data depends on the record's use, as shown in the following sections.

This record is used very rarely and is usually not required; for most applications, the default size and position settings are sufficient. If your application writes chart BIFF, use the default settings whenever possible. To use the default plot area, set the fManPlotArea bit in the SHTPROPS record. To use a default legend position and size, set the fAutoPosition bit in the LEGEND record, and set the fAutoSize bit in the legend FRAME record. No other settings are required to use the default position for text (data labels, axis labels, and chart title).

Plot Area

The POS record is used only for the main axis. The record describes the plot-area bounding box (the plot-area bounding box includes the plot area, tick marks, and a small border around the tick marks). The fManPlotArea bit in the SHTPROPS record must be 1, or the POS record is ignored.

The top left position, width, and height fields use units of 1/4000 of the chart area.

Record Data

Offset

Name

Size

Contents

4

mdTopLt

2

Must be 2

6

mdBotRt

2

Must be 2

8

x1

4

x coordinate of bounding box top left corner

12

y1

4

y coordinate of bounding box top left corner

16

x2

4

width of the bounding box

20

y2

4

height of the bounding box


Legend

The POS record describes the legend position and size.

Record Data

Offset

Name

Size

Contents

4

mdTopLt

2

Must be 5

6

mdBotRt

2

1 = use x2 and y2 for legend size
2 = autosize legend (ignore x2, y2). The fAutoSize bit of the legend FRAME record should be 1 if this field is 2.

8

x1

4

x coordinate of legend top left corner, in units of 1/4000 of the chart area

12

y1

4

y coordinate of legend top left corner, in units of 1/4000 of the chart area

16

x2

4

width of the legend, in points (1/72 inch)

20

y2

4

height of the legend, in points


Text (Chart Title)

The POS record sets the chart title position as an offset from the default position, in units of 1/4000 of the chart area.

Record Data

Offset

Name

Size

Contents

4

mdTopLt

2

Must be 2

6

mdTopRt

2

Must be 2

8

x1

4

offset from default horizontal position

12

y1

4

offset from default vertical position

16

x2

4

ignored (you cannot size the chart title)

20

y2

4

ignored


Text (Axis Title)

The POS record sets the axis title position as an offset from the default position.

Record Data

Offset

Name

Size

Contents

4

mdTopLt

2

Must be 2

6

mdTopRt

2

Must be 2

8

x1

4

offset perpendicular to the axis, in units of 1/1000 of the plot-area bounding box

12

y1

4

offset parallel to the axis, in units of 1/1000 of the axis length

16

x2

4

ignored (you cannot size the axis title)

20

y2

4

ignored


Text (Data Labels)

The POS record sets the label position as an offset from the default position.

Record Data

Offset

Name

Size

Contents

4

mdTopLt

2

Must be 2

6

mdTopRt

2

Must be 2

8

x1

4

Pie charts: offset angle from the default, in radians
Bar and Column charts: offset perpendicular to the bar or column, in units of 1/1000 of the plot area
All other chart types: horizontal offset from the default position, in units of 1/1000 of the plot area

12

y1

4

Pie charts: radial offset, in units of 1/1000 of the pie radius
Bar and Column charts: offset parallel to the bar or column, in units of 1/1000 of the plot area
All other chart types: vertical offset from the default position, in units of 1/1000 of the plot area

16

x2

4

ignored (you cannot size the data label)

20

y2

4

ignored