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).
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 |
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 |
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 |
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 |
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 |
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 |
12 |
y1 |
4 |
Pie charts: radial offset, in units of 1/1000 of the pie radius |
16 |
x2 |
4 |
ignored (you cannot size the data label) |
20 |
y2 |
4 |
ignored |