DS.Documents.Excel Assembly

GrapeCity.Documents.Excel.Drawing.IChart

IChart Interface

Represents a chart object in a worksheet.

Namespace: GrapeCity.Documents.Excel.Drawing

Assembly: DS.Documents.Excel.dll

Syntax

public interface IChart

Public Interface IChart

Properties

Name	Description
Area3DGroup	Returns the IChartGroup object that represents the area chart group on a 3-D chart.
AreaGroups	Returns an object that represents a collection of the area chart groups IChartGroups, on a 2D chart.
AutoScaling	Gets or sets the scaling (True to scale a 3-D chart so that it's closer in size to the equivalent 2-D chart. The RightAngleAxes property must be True).
Axes	Returns an object that represents a collection of the axes on the chart.
BackWall	Returns the IWall object that allows the user to individually format the back wall of a 3-D chart.
Bar3DGroup	Returns the IChartGroup object that represents the bar chart group on a 3-D chart.
BarGroups	Returns an object that represents a collection of the bar chart groups IChartGroups, on a 2D chart.
BarShape	Returns or sets the shape used with the 3-D bar or column chart.
ChartArea	Returns the IChartArea object that represents the complete chart area for the chart.
ChartGroups	Returns an object that represents a collection of all the chart groups in the chart IChartGroups. The returned collection includes every type of group.
ChartTitle	Returns the IChartTitle object that represents the title of the specified chart.
ChartType	Returns or sets the chart type.
Column3DGroup	Returns the IChartGroup object that represents the column chart group on a 3-D chart.
ColumnGroups	Returns an object that represents a collection of the column chart groups IChartGroups, on a 2D chart.
DataTable	Returns the IDataTable object that represents the chart data table.
DepthPercent	Returns or sets the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent).
DisplayBlanksAs	Returns or sets the way that blank cells are plotted on a chart. Can be one of the following: DisplayBlanksAs constants: NotPlotted, Interpolated, or Zero.
DisplayNaAsBlank	specifies whether to treat cells containing #N/A as if they were blank cells.
DoughnutGroups	Returns an object that represents a collection of the doughnut chart groups IChartGroups, on a 2D chart.
Elevation	Returns or sets the elevation of the 3-D chart view in degrees.
Floor	Returns the IFloor object that represents the floor of the 3-D chart.
GapDepth	Returns 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.
HasDataTable	Gets or sets a value indicating whether the chart displays a data table.
HasLegend	Gets or sets whether the chart has a legend.
HasTitle	Gets or sets whether the axis or chart has a visible title.
HeightPercent	Returns or sets the height of a 3-D chart as a percentage of the chart width (between 5 and 500 percent).
Legend	Returns the ILegend object that represents the legend for the chart.
Line3DGroup	Returns the IChartGroup object that represents the line chart group on a 3-D chart.
LineGroups	Returns an object that represents a collection of the line chart groups IChartGroups, on a 2D chart.
Name	Returns the name of the object.
Parent	Returns the parent IShape of the chart.
Perspective	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.
Pie3DGroup	Returns the IChartGroup object that represents the pie chart group on a 3-D chart.
PieGroups	Returns an object that represents a collection of the pie chart groups IChartGroups, on a 2D chart.
PivotOptions	Returns a IPivotOptions object that represents the options whether to display pivot chart buttons.
PivotTable	Returns a IPivotTable object that represents the PivotTable report containing the upper-left corner of the specified range, or the PivotTable report associated with the PivotChart report.
PlotArea	Returns the IPlotArea object that represents the plot area of a chart.
PlotVisibleOnly	Gets or sets whether visible cells are plotted. True if only visible cells are plotted. False if both visible and hidden cells are plotted.
RadarGroups	Returns an object that represents a collection of the radar chart groups IChartGroups, on a 2D chart.
RightAngleAxes	Gets or sets whether the chart axes are at right angles, independent of chart rotation or elevation. Applies only to 3-D line, column, and bar charts.
Rotation	Returns or sets the rotation of the 3-D chart view (the rotation of the plot area around the z-axis in degrees). The value of this property must be from 0 to 360, except for 3-D bar charts, where the value must be from 0 to 44. The default value is 20. Applies only to 3-D charts.
SeriesCollection	Returns an object that represents a collection of all the series in the chart.
Shapes	Returns all drawing shapes in this chart.
ShowDataLabelsOverMaximum	Gets or sets whether to show the data labels when the value is greater than the maximum value on the value axis.
SideWall	Returns the IWall object that allows the user to individually format the side wall of a 3-D chart.
SurfaceGroup	Returns the IChartGroup object that represents the surface chart group of a 3-D chart.
Walls	Returns the IWall object that represents the walls of the 3-D chart.
XYGroups	Returns an object that represents a collection of the scatter chart groups IChartGroups, on a 2D chart.

Methods

Name	Description
AddChart(ChartType, double, double, double, double)	Creates a chart at the specified location on the chart.
AddChartInPixel(ChartType, double, double, double, double)	Creates a chart at the specified location on the active sheet.
AddConnector(ConnectorType, double, double, double, double)	Creates a connector. Returns the IShape object that represents the new connector.
AddConnectorInPixel(ConnectorType, double, double, double, double)	Creates a connector. Returns the IShape object that represents the new connector.
AddPicture(Stream, ImageType, double, double, double, double)	Creates a picture from an existing stream. Returns the IShape object that represents the new picture.
AddPicture(string, double, double, double, double)	Creates a picture from an existing file. Returns the IShape object that represents the new picture.
AddPictureInPixel(Stream, ImageType, double, double, double, double)	Creates a picture from an existing stream. Returns the IShape object that represents the new picture.
AddPictureInPixel(string, double, double, double, double)	Creates a picture from an existing file. Returns the IShape object that represents the new picture.
AddShape(AutoShapeType, double, double, double, double)	Returns the IShape object that represents the new AutoShape in the chart.
AddShapeInPixel(AutoShapeType, double, double, double, double)	Returns the IShape object that represents the new AutoShape in a worksheet.
Delete()	Deletes the object.
SetSourceData(IRange)	Sets the source data range for the chart.
SetSourceData(IRange, RowCol)	Sets the source data range for the chart.