GrapeCity.Spreadsheet.Charts.IChart

IChart Interface

Represents a chart in a workbook.

Namespace: GrapeCity.Spreadsheet.Charts

Assembly: GrapeCity.Spreadsheet.dll

Syntax

public interface IChart

Public Interface IChart

Properties

Name	Description
AutoScaling	`true` if scales a 3D chart so that it's closer in size to the equivalent 2D chart and `false` otherwise.
Axes	Gets a collection of the axes on the chart.
BackWall	Gets an IWalls object that allows the user to individually format the back wall of a 3D chart.
BarShape	Gets or sets the shape used with the 3D bar or column chart.
ChartArea	Gets an IChartArea object that represents the complete chart area for the chart.
ChartColor	Gets or sets an Integer that represents the color scheme for the chart.
ChartGroups	Gets an object that represents a collection of all the chart groups in the chart.
ChartStyle	Gets or sets the chart style for the chart.
ChartTitle	Gets a IChartTitle object that represents the title of the specified chart.
ChartType	Gets or sets the chart type.
DataTable	Gets an IDataTable object that represents the chart data table.
DepthPercent	Gets or sets the depth of a 3D chart as a percentage of the chart width (between 20 and 2000 percent).
DisplayBlanksAs	Gets or sets the way that blank cells are plotted on a chart.
DisplayValueNotAvailableAsBlank	Gets or sets a value indicating whether the #N/A error is plotted as a blank cell.
Elevation	Gets or sets the elevation of the 3D chart view, in degrees.
Floor	Gets a IFloor object that represents the floor of the 3D chart.
GapDepth	Get or sets the distance between the data series in a 3D chart as a percentage of the marker width. The value of this property must be between 0 and 500.
HeightPercent	Gets or sets the height of a 3D chart as a percentage of the chart width.
Index	Gets an integer value that represents the index number of the chart within the collection.
Legend	Gets an ILegend object that represents the legend for the chart.
Perspective	Gets or sets a value that represents the perspective for the 3D chart view.
PlotArea	Gets an IPlotArea object that represents the plot area of a chart.
PlotBy	Gets or sets the way columns or rows are used as data series on the chart.
PlotVisibleOnly	Gets or sets a value indicating whether only visible cells are plotted.
RightAngleAxes	Gets or sets a value indicating whether the chart axes are at right angles, independent of chart rotation or elevation.
Rotation	Gets or sets the rotation of the 3D chart view (the rotation of the plot area around the y-axis, in degrees).
Series	Gets an object that represents all the series in the chart or chart group.
Shapes	Gets a IShapes collection that represents all the shapes on the chart sheet.
SideWall	Gets an IWalls object that allows the user to individually format the side wall of a 3D chart.
Walls	Gets an IWalls object that represents the walls of the 3D chart.

Methods

Name	Description
ApplyDataLabels(DataLabelVisibilities, string)	Applies data labels to all series in chart.
ApplyLayout(int, ChartType)	Applies the layouts shown in the ribbon.
ClearToMatchStyle()	Clears the chart elements formatting to automatic.
Location(ChartLocation, string)	Moves the chart to a new location.
Protect(ChartLocks, string)	Protects a chart so that it cannot be modified.
SetSourceData(IRange, RowCol?)	Sets the source data range for the chart.
SetSourceData(WorksheetReference, RowCol?)	Sets the source data range for the chart.
SetSourceData(string, RowCol?)	Sets the source data range for the chart.
ShowAxis(AxisType, AxisGroup)	Displays the axis specified by AxisType and AxisGroup.
ShowDataTable()	Displays the data table on the chart.
ShowLegend()	Displays the legend on the chart.
ShowTitle()	Displays the title of chart.

Events

Name	Description
BeforeRightClick	Occurs when the chart is right-clicked, before the default right-click action.
ElementSelected	Occurs when a chart element is selected.
ElementSelecting	Occurs when a chart element is selected.