ChartSection (Object)

Member of:

Sections collection, Document object (ActiveSection)

Description:

Represents a chart section.

Example:

This example activates the Sales Chart section, activates the legend, changes the title to International Sales Report, changes the chart to horizontal bar, and exports the chart as intlchrt.htm:

myChart = ActiveDocument.Sections["Sales Chart"]
myChart.Activate()
myChart.ShowLegend = true
myChart.Title = "International Sales Report"
myChart.ChartType = bqChartTypeHorizontalBar
myChart.Export("c:\\html\\intlchrt.htm",bqExportFormatHTML,true)

Methods:

Activate(), Copy(), Duplicate(), Export([Filename As String], [FileFormat As BqExportFileFormat], [IncludeHeaders As Boolean], [Prompt as Boolean]), PivotThisChart() As PivotSection, PrintOut([FromPage As Number], [ToPage As Number], [Copies As Number], [Filename As String], [Prompt As Boolean]), Recalculate(), RefreshDataNow(), Remove()

Properties:

Read-only: Property Active As Boolean, Property LastPrinted as Date, Property Type As BqSectionType

Read-write: Property AutoResize as Boolean, Property AutoRotate as Boolean, Property ChartType As BqChartType, Property ColorScheme as qChartColorScheme, Property HTMLBoundaryHeight as Number, Property HTMLBoundaryMode as Boolean, Property HTMLBoundaryWidth as Number, Property HTMLDisplayXViews as Boolean, HTMLDisplayZViews as Boolean, HTMLMaximumXBarsDisplayed as Number, HTMLMaximumZBarsDisplayed, Property HTMLSyncScrollingProps as Boolean, , Property MinimumFontSize as Number, Property Name As String, Property PrintAllViews as Boolean, Property RefreshData as BqRefreshData, Property RotationHorizontal as Number, RotationVertical as Number, Property Show3DObjects As Boolean, Property ShowBackPlane as Boolean, Property ShowBorder As Boolean, Property ShowHorizontalPlane As Boolean, Property ShowLegend As Boolean, Property ShowOutliner As Boolean, Property ShowPartialViewIndicator as Boolean, Property ShowSortLine as Boolean, Property ShowSubTitle As Boolean, Property ShowTitle As Boolean, Property ShowVerticalPlane As Boolean, Property SmartScaling as Boolean, Property SubTitle As String, Property Title As String, Property UseLegacyColors as Boolean, Property Visible As Boolean

Collections:

XCategories As CategoryItems, Facts As CategoryItems, ZCategories As CategoryItems, XLabels As AxisLabels, YLabels As AxisLabels, ZLabels As AxisLabels, UserValues as UserValues

Objects:

AreaChart As AreaChart, BarChart As BarChart, BarLineChart As BarLineChart, ColorSet, LabelsAxis As LabelsAxis, Legend as Legend, LineChart As LineChart, PieChart As PieChart , ValuesAxis As ValuesAxis, Legend As Legend