Type property (Excel Graph)
The Type property as it applies to the following objects.
Returns or sets the axis type. Read/write XlAxisType.
expression.Type
expression Required. An expression that returns an Axis object.
Returns the color type. Read-only Long.
expression.Type
expression Required. An expression that returns a ChartColorFormat object.
Returns the fill type. Read-only MsoFillType.
expression.Type
expression Required. An expression that returns a ChartFillFormat object.
Returns or sets the data label type. Read/write Variant.
expression.Type
expression Required. An expression that returns a DataLabel object or DataLabels collection.
Returns or sets the series type. Read/write Long.
expression.Type
expression Required. An expression that returns a Series object.
Returns or sets the trendline type. Read/write XlTrendlineType.
expression.Type
expression Required. An expression that returns a 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
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.