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