Type Property
Type property as it applies to the Axis object.
Returns or sets the axis type. Read/write XlAxisType.
| XlAxisType can be one of these XlAxisType constants. |
| xlSeriesAxis |
| xlCategory |
| xlValue |
expression.TypeexpressionRequired. An expression that returns an Axisobject.
Type property as it applies to the ChartColorFormat object.
Returns the color type. Read-only Long.
expression.TypeexpressionRequired. An expression that returns a ChartColorFormatobject.
Type property as it applies to the ChartFillFormat object.
Returns the fill type. Read-only MsoFillType.
| MsoFillType can be one of these MsoFillType constants. |
| msoFillGradient |
| msoFillBackground |
| msoFillMixed |
| msoFillPatterned |
| msoFillPicture |
| msoFillSolid |
| msoFillTextured |
expression.TypeexpressionRequired. An expression that returns a ChartFillFormatobject.
Type property as it applies to the DataLabel and DataLabels objects.
Returns or sets the data label type. Read/write Variant.
expression.TypeexpressionRequired. An expression that returns one of the above objects.
Type property as it applies to the Series object.
Returns or sets the series type. Read/write Long.
expression.TypeexpressionRequired. An expression that returns a Seriesobject.
Type property as it applies to the Trendline object.
Returns or sets the trendline type. Read/write XlTrendlineType.
| XlTrendlineType can be one of these XlTrendlineType constants. |
| xlExponential |
| xlLinear |
| xlLogarithmic |
| xlMovingAvg |
| xlPolynomial |
| xlPower |
expression.TypeexpressionRequired. An expression that returns a Trendlineobject.
Example
As it applies to the Trendline object.
This example changes the trendline type for the first series in the chart. If the series has no trendline, this example fails.
|