Type Element (Microsoft Excel)

Specifies the type of axis scaling, chart, data source, 3-D shape, or trendline, the data validation constraints on data entered into a range, or the position of legend entries.

Contained In

Axis, DataSource, DataValidation, Graph, Legend, Shape, Trendline

Remarks

For data validation, the constraint is some characteristic of the data, such as the data type or the length. This element contains one of the following string constants: Custom, Date, Decimal, List, TextLength, Time, or Whole. The default value is AnyValue.

For an axis, this element contains one of the following string constants specifying the scaling: Automatic, Category, Series, Value, or TimeScale.

For a chart data source, this element contains one of the following string constants.

The Connection element contains the name of the component.

For a legend, this element contains one of the following string constants specifying the position of legend entries.

Constant	Description
Automatic	Microsoft Excel or the Chart component determines the optimal position of entries.
Horizontal	Entries are arranged in columns.
Vertical	Entries are arranged in a single column.

For a shape, this element contains one of the following string constants specifying the type of 3-D shape: Cube, Cone, Cone Frustum, Cylinder, Pyramid, or Pyramid Frustum.

For a trendline, this element contains one of the following string constants specifying the type of trendline: Exponential, Linear, Logarithmic, MovingAverage, Polynomial, or Power.

For a Graph element, the Type and SubType subelements each contain values for string constants from the following table specifying the type of chart. In the SubType column of the following table, constants within square brackets ([]) are optional, and the vertical bar (|) indicates a logical OR relationship. For example, "Standard [Marker | 3D]" means that the SubType element can contain Standard, Standard Marker, or Standard 3D. Attributes can also be specified separately. To indicate subtype attributes individually, such as "Stacked" and "3D", use a SubType element containing the string constant Stacked followed by another SubType element containing the string constant 3D.

Type	SubType
Column	Clustered [3D] [Cylinder] [Pyramid] [Cone] Stacked [3D] [Cylinder] [Pyramid] [Cone] 100% Stacked [3D] [Cylinder] [Pyramid] [Cone] 3D [Cylinder] [Pyramid] [Cone]
Bar	Clustered [3D] [Cylinder] [Pyramid] [Cone] Stacked [3D] [Cylinder] [Pyramid] [Cone] 100% Stacked [3D] [Cylinder] [Pyramid] [Cone] 3D [Cylinder] [Pyramid] [Cone]
Line	Standard [Marker | 3D] [Smooth] [Rotated] Stacked [Marker | 3D] [Smooth] [Rotated] 100% Stacked [Marker | 3D] [Smooth] [Rotated] 3D
Pie	Standard [3D] Exploded [3D] of Bar of Pie
Scatter	Marker [Rotated] Line [Smooth] [Marker] [Rotated] Filled [Rotated]
Area	Standard [3D] [Rotated] Stacked [3D] [Rotated] 100% Stacked [3D] [Rotated]
Doughnut	Standard Exploded
Radar	Standard [Smooth] [Marker] [Rotated] Filled [Rotated]
Surface	Contour [Wireframe] 3D [Wireframe]
Bubble	Standard [3D] [Rotated] Line [Rotated]
Stock	High-Low-Close [Rotated] Open-High-Low-Close [Rotated]
Polar	Marker [Line] [Smooth]

Microsoft Excel does not load or save charts of type Stock, but they can be saved by the Chart component. In Excel, you can choose whether these charts appear as line or line and column graphs.

The order of the Axis subelements determines the primary and secondary axes. The first Axis subelement whose ScaleID subelement contains the same identifier as the ScaleID subelement of their parent Graph element is used as the primary axis. The axes used by the first graph to use a primary axis become the primary axes.

Examples

See the examples in the DataValidation and WebChart element topics.