Expand Minimize

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.Type

expression Required. An expression that returns an Axis object.

Type property as it applies to the ChartColorFormat object.

Returns the color type. Read-only Long.

expression.Type

expression Required. An expression that returns a ChartColorFormat object.

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.Type

expression Required. An expression that returns a ChartFillFormat object.

Type property as it applies to the DataLabel and DataLabels objects.

Returns or sets the data label type. Read/write Variant.

expression.Type

expression Required. 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.Type

expression Required. An expression that returns a Series object.

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.Type

expression Required. An expression that returns a Trendline object.

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.

myChart.SeriesCollection(1).Trendlines(1).Type = xlMovingAvg

Community Additions

ADD
Show:
© 2014 Microsoft