Placement Element (Microsoft Excel)

Specifies the position of an axis or legend within a chart.

Contained In

Axis, Legend

Remarks

For a Chart component, this element contains one of the following string constants specifying the position of the axis: Bottom, Left, Right, or Top. In Microsoft Excel, the default placement depends on the axis type. The primary value axis appears on the left and the primary category axis at the bottom, while the secondary value axis appears on the right and the secondary category axis at the top. Bar charts appear with the primary value axis on the bottom and the primary category axis on the left, while the secondary value axis appears on the top and the secondary category axis at the right.

For a legend, this element contains one of the following string constants specifying the position: Automatic, Bottom, Corner, Custom, Left, None, Right, or Top.

When this element contains the string constant None, the legend is hidden. The subelements of the Legend element contain formatting properties that are used if the legend becomes visible.

When this element contains the string constant Custom, the Height, Left, Top, and Width elements specify the exact position of the legend relative to the top left corner of the chart.

Example

See the example in the WebChart element topic.