Type Property

Microsoft Graph Visual Basic

Show All

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.

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.

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