Chart Class
Contents
[
Hide
]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. |
| ChangeTemplate | Change chart type with preset template. |
| 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 SeriesCollection collection representing the data series in the chart. |
| GetFilteredNSeries | Gets a SeriesCollection 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 Floor object that represents the walls of a 3-D chart. |
| GetWalls | Returns a Walls object that represents the walls of a 3-D chart. |
| GetBackWall | Returns a Walls object that represents the back wall of a 3-D chart. |
| GetSideWall | Returns a Walls 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_Int64 | Creates the chart image and saves it to a stream in the Jpeg format. |
| ToImage_ImageType | Creates the chart image and saves it to a stream in the specified format. |
| ToPdf_String | Saves the chart to a pdf file. |
| ToPdf_String_Float_Float_PageLayoutAlignmentType_PageLayoutAlignmentType | Saves the chart to a pdf file. |
| ToPdf | Creates the chart pdf and saves it to a stream. |
| ToPdf_Float_Float_PageLayoutAlignmentType_PageLayoutAlignmentType | Creates the chart pdf and saves it to a stream. |
| 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. |
| ToImage_ImageOrPrintOptions | Creates the chart image and saves it to a stream in the specified format. |
| GetActualSize | Gets actual size of chart in unit of pixels. |
| 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. |