ChartType (Property)

Applies To:

ChartSection object

Description:

Sets which type of chart is displayed in a Chart section.

Action:

Read-write

Constants:

The BqChartType constant group consists of these values:

bqChartTypeArea
bqChartTypeAreaLine
bqChartTypeBarLine
bqChartTypeClusterBar
bqChartTypeHorizontalBar
bqChartTypeHorizontalStackBar
bqChartTypeLine
bqChartTypeNone
bqChartTypePie
bqChartTypeRibbon
bqChartTypeStackArea
bqChartTypeVerticalBar
bqChartTypeVerticalStackBar

Example:

This example shows how to change chart properties based on the chart type:

if (ActiveDocument.Sections["Chart"].ChartType == bqChartTypeBarLine)
{
ActiveDocument.Sections["Chart"].BarLineChart.ClusterBy = bqClusterByZ
ActiveDocument.Sections["Chart"].BarLineChart.IgnoreNulls = false
ActiveDocument.Sections["Chart"].BarLineChart.ShiftPoints = bqShiftCenter
ActiveDocument.Sections["Chart"].BarLineChart.StackClusterType = bqBarLineCluster
ActiveDocument.Sections["Chart"].BarLineChart.ShowBarValues = false
}