Chart Class

Chart class

Encapsulates the object that represents a single Excel chart.

type Chart struct  {
	ptr unsafe.Pointer
}

Constructors

Method	Description

Methods

Method	Description
IsNull	Checks whether the implementation object is nullptr.
GetStyle	Gets and sets the builtin style.
SetStyle	Gets and sets the builtin style.
GetChartObject	Represents the chartShape;
GetHidePivotFieldButtons	Indicates whether hide the pivot chart field buttons only when the chart is PivotChart.
SetHidePivotFieldButtons	Indicates whether hide the pivot chart field buttons only when the chart is PivotChart.
GetPivotOptions	Specifies the pivot controls that appear on the chart
GetPivotSource	The source is the data of the pivotTable.If PivotSource is not empty ,the chart is PivotChart.
SetPivotSource	The source is the data of the pivotTable.If PivotSource is not empty ,the chart is PivotChart.
IsCellReferedByChart	Returns whether the cell refered by the chart.
IsChartDataChanged	Detects if a chart’s data source has changed.
GetPlotBy	Gets and sets whether plot by row or column.
RefreshPivotData	Refreshes chart’s data from pivot table.
GetPlotEmptyCellsType	Gets and sets how to plot the empty cells.
SetPlotEmptyCellsType	Gets and sets how to plot the empty cells.
GetPlotVisibleCellsOnly	Indicates whether plot visible cells only.
SetPlotVisibleCellsOnly	Indicates whether plot visible cells only.
GetDisplayNaAsBlank	Indicates whether displaying #N/A as blank value.
SetDisplayNaAsBlank	Indicates whether displaying #N/A as blank value.
GetName	Gets and sets the name of the chart.
SetName	Gets and sets the name of the chart.
GetSizeWithWindow	True if Microsoft Excel resizes the chart to match the size of the chart sheet window.
SetSizeWithWindow	True if Microsoft Excel resizes the chart to match the size of the chart sheet window.
GetWorksheet	Gets the worksheet which contains this chart.
GetShapes	Returns all drawing shapes in this chart.
GetPrintSize	Gets and sets the printed chart size.
SetPrintSize	Gets and sets the printed chart size.
GetType	Gets or sets a chart’s type.
SetType	Gets or sets a chart’s type.
Move	Moves the chart to a specified location.
GetNSeries	Gets a collection representing the data series in the chart.
GetFilteredNSeries	Gets a collection representing the data series that are filtered in the chart.
GetTitle	Gets the chart’s title.
GetSubTitle	Gets the chart’s sub-title.Only for ODS format file.
GetPlotArea	Gets the chart’s plot area which includes axis tick labels.
GetChartArea	Gets the chart area in the worksheet.
GetCategoryAxis	Gets the chart’s X axis.
GetValueAxis	Gets the chart’s Y axis.
GetSecondValueAxis	Gets the chart’s second Y axis.
GetSecondCategoryAxis	Gets the chart’s second X axis.
GetSeriesAxis	Gets the chart’s series axis.
GetLegend	Gets the chart legend.
GetChartDataTable	Represents the chart data table.
GetShowLegend	Gets or sets a value indicating whether the chart legend will be displayed. Default is true.
SetShowLegend	Gets or sets a value indicating whether the chart legend will be displayed. Default is true.
IsRectangularCornered	Gets or sets a value indicating whether the chart area is rectangular cornered.Default is true.
SetIsRectangularCornered	Gets or sets a value indicating whether the chart area is rectangular cornered.Default is true.
GetShowDataTable	Gets or sets a value indicating whether the chart displays a data table.
SetShowDataTable	Gets or sets a value indicating whether the chart displays a data table.
GetFirstSliceAngle	Gets or sets the angle of the first pie-chart or doughnut-chart slice, in degrees (clockwise from vertical).Applies only to pie, 3-D pie, and doughnut charts, 0 to 360.
SetFirstSliceAngle	Gets or sets the angle of the first pie-chart or doughnut-chart slice, in degrees (clockwise from vertical).Applies only to pie, 3-D pie, and doughnut charts, 0 to 360.
GetGapWidth	Returns or sets the space between bar or column clusters, as a percentage of the bar or column width.The value of this property must be between 0 and 500.
SetGapWidth	Returns or sets the space between bar or column clusters, as a percentage of the bar or column width.The value of this property must be between 0 and 500.
GetGapDepth	Gets or sets the distance between the data series in a 3-D chart, as a percentage of the marker width.The value of this property must be between 0 and 500.
SetGapDepth	Gets or sets the distance between the data series in a 3-D chart, as a percentage of the marker width.The value of this property must be between 0 and 500.
Calculate	Calculates the custom position of plot area, axes if the position of them are auto assigned.
Calculate_ChartCalculateOptions	Calculates the custom position of plot area, axes if the position of them are auto assigned, with Chart Calculate Options.
GetFloor	Returns a object that represents the walls of a 3-D chart.
GetWalls	Returns a object that represents the walls of a 3-D chart.
GetBackWall	Returns a object that represents the back wall of a 3-D chart.
GetSideWall	Returns a object that represents the side wall of a 3-D chart.
GetWallsAndGridlines2D	True if gridlines are drawn two-dimensionally on a 3-D chart.
SetWallsAndGridlines2D	True if gridlines are drawn two-dimensionally on a 3-D chart.
GetRotationAngle	Represents the rotation of the 3-D chart view (the rotation of the plot area around the z-axis, in degrees).
SetRotationAngle	Represents the rotation of the 3-D chart view (the rotation of the plot area around the z-axis, in degrees).
GetElevation	Represents the elevation of the 3-D chart view, in degrees.
SetElevation	Represents the elevation of the 3-D chart view, in degrees.
GetRightAngleAxes	True if the chart axes are at right angles. Applies only for 3-D charts(except Column3D and 3-D Pie Charts).
SetRightAngleAxes	True if the chart axes are at right angles. Applies only for 3-D charts(except Column3D and 3-D Pie Charts).
GetAutoScaling	True if Microsoft Excel scales a 3-D chart so that it’s closer in size to the equivalent 2-D chart.The RightAngleAxes property must be True.
SetAutoScaling	True if Microsoft Excel scales a 3-D chart so that it’s closer in size to the equivalent 2-D chart.The RightAngleAxes property must be True.
GetHeightPercent	Returns or sets the height of a 3-D chart as a percentage of the chart width (between 5 and 500 percent).
SetHeightPercent	Returns or sets the height of a 3-D chart as a percentage of the chart width (between 5 and 500 percent).
GetPerspective	Returns or sets the perspective for the 3-D chart view. Must be between 0 and 100.This property is ignored if the RightAngleAxes property is True.
SetPerspective	Returns or sets the perspective for the 3-D chart view. Must be between 0 and 100.This property is ignored if the RightAngleAxes property is True.
GetIs3D	Indicates whether the chart is a 3d chart.
GetDepthPercent	Represents the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent).
SetDepthPercent	Represents the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent).
ToImage_String	Creates the chart image and saves it to a file.The extension of the file name determines the format of the image.
ToImage_String_ImageType	Creates the chart image and saves it to a file in the specified image type.
ToImage_String_Int	Creates the chart image and saves it to a file in the Jpeg format.
ToPdf_String	Saves the chart to a pdf file.
ToPdf_String_Float_Float_PageLayoutAlignmentType_PageLayoutAlignmentType	Saves the chart to a pdf file.
ToImage_String_ImageOrPrintOptions	Creates the chart image and saves it to a file.The extension of the file name determines the format of the image.
GetPlacement	Represents the way the chart is attached to the cells below it.
SetPlacement	Represents the way the chart is attached to the cells below it.
GetPageSetup	Represents the page setup description in this chart.
HasAxis	Returns which axes exist on the chart.
SwitchRowColumn	Switches row/column.
GetChartDataRange	Gets the data source range of the chart.
SetChartDataRange	Specifies data range for a chart.
GetLine	Gets the line.