Chart.ChartType Property

Returns or sets the chart type. Read/write XlChartType.

Syntax

expression.ChartType

expression   A variable that represents a Chart object.

Remarks

Some chart types aren’t available for PivotChart reports.

Example

This example sets the bubble size in chart group one to 200% of the default size if the chart is a 2D bubble chart.

  With Worksheets(1).ChartObjects(1).Chart
    If .ChartType = xlBubble Then
        .ChartGroups(1).BubbleScale = 200
    End If
End With

See Also

• Chart Object
• Chart Object Members