Applies To
Axis Object, Chart Object, ChartGroup Object, DataLabel Object, DataLabels Collection, Series Object, Trendline Object, Window Object, Worksheet Object.
Description
Returns the object type, as shown in the following table. Read-write except as noted.
|
Object |
Type |
|
Axis |
Axis type. Can be one of xlCategory, xlValue, or xlSeries (only 3-D charts use xlSeries). |
|
Chart |
Chart type. Can be one of xl3DArea, xl3DBar, xl3DColumn, xl3DLine, xl3DPie, xl3DSurface, xlArea, xlBar, xlColumn, xlDoughnut, xlLine, xlPie, xlRadar, or xlXYScatter. If the chart has chart groups of more than one type, this property returns Null, but setting the property sets all the chart groups. |
|
ChartGroup |
Chart group type. Can be one of the values shown for the Chart object. If you set the chart group type to a type that is not on the chart, Microsoft Excel creates a new chart group. |
|
DataLabel |
Data label type (one of xlNone, xlShowValue, xlShowLabel, xlShowPercent, or xlShowLabelAndPercent). |
|
Series |
Series type. Can be one of the values shown for the Chart object. If you set the series type to a type that is not on the chart, Microsoft Excel creates a new chart group. |
|
Trendline |
Trendline type. Can be one of xlLinear, xlLogarithmic, xlExponential, xlPolynomial, xlMovingAvg, or xlPower. |
|
Window |
Window type. Can be one of xlChartInPlace, xlChartAsWindow, xlWorkbook, xlInfo, or xlClipboard. Read-only. |
|
Worksheet |
Worksheet type. Can be one of xlWorksheet, xlExcel4MacroSheet, or xlExcel4IntlMacroSheet. Read-only. |
See Also
SubType Property.
Example
This example changes the 3-D line group in Chart1 to an area group. The example should be run on a 3-D chart.
Charts("Chart1").Line3DGroup.Type = xl3DArea