Chart.ChartType Property

  • Article
Excel Developer Reference

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.

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

See Also