Table of contents
TOC
Collapse the table of content
Expand the table of content

Chart.ChartType Property (Project)

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

Gets or sets the chart type. Read/write Office.XlChartType.

Syntax

expression. ChartType

expression A variable that represents a Chart object.

Remarks

The ChartType property corresponds to an action in the Change Chart Type dialog box. The command is on the ribbon under CHART TOOLS, on the DESIGN tab.

Example

The following example changes a clustered column chart to a clustered 3-D column chart type.

Sub SwitchChartTo3D()
    Dim chartShape As Shape

    Set chartShape = ActiveProject.Reports("Simple scalar chart").Shapes(1)

    With chartShape.Chart
        Debug.Print .ChartType

        If .ChartType = xlColumnClustered Then
            .ChartType = xl3DColumnClustered
        End If
    End With
End Sub

Property value

XLCHARTTYPE

See also

Other resources

Chart Object

© 2018 Microsoft