Version

WorksheetChart Class Members

The following tables list the members exposed by WorksheetChart.

Public Properties
 NameDescription
Public PropertyAutoScalingTrue 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  
Public PropertyAxisCollectionReturns the axis collection (read-only)  
Public PropertyBackWallReturns a Infragistics.Documents.Excel.Charts.Wall object that allows the user to format the back wall of a 3-D chart. Read-only.  
Public PropertyBarShapeReturns or sets the shape of Infragistics.Documents.Excel.Charts.Series bars. Applicable only to 3D bar-type charts.  
Public PropertyBarShapeResolvedReturns the resolved value of the BarShape property.  
Public PropertyBottomRightCornerCellGets or sets the cell where the bottom-right corner of the shape resides. (Inherited from Infragistics.Documents.Excel.WorksheetShape)
Public PropertyBottomRightCornerPositionGets or sets the position in the WorksheetShape.BottomRightCornerCell of the shape's bottom-right corner, expressed in percentages. (Inherited from Infragistics.Documents.Excel.WorksheetShape)
Public PropertyChartAreaReturns a ChartArea object that represents the complete chart area for the chart. Read-only.  
Public PropertyChartTitleReturns or sets an ChartTitle object.  
Public PropertyChartTypeSpecifies the chart type.  
Public PropertyComboChartGroupsReturns a collection of the ComboChartGroup instances associated with this chart.  
Public PropertyDepthPercentReturns or sets the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent).  
Public PropertyDisplayBlanksAsReturns or sets the way that blank cells are plotted on a chart.  
Public PropertyDoughnutHoleSizeReturns or sets the size of the hole in a doughnut chart, expressed as a percentage of the size of the encompassing circle.  
Public PropertyDropLinesReturns or sets a Infragistics.Documents.Excel.Charts.ChartDropLines instance which determines the appearance for a stock chart's drop lines.  
Public PropertyFillGets or sets the fill to use in the background of the shape. (Inherited from Infragistics.Documents.Excel.WorksheetShape)
Public PropertyFirstSliceAngleReturns or sets the angle which determines the origin of the first slice, as relative to the 12 o'clock position of the emcompassing circle.  
Public PropertyFlippedHorizontallyGets or sets the value which indicates whether the shape is flipped horizontally along the vertical center line. (Inherited from Infragistics.Documents.Excel.WorksheetShape)
Public PropertyFlippedVerticallyGets or sets the value which indicates whether the shape is flipped vertically along the horizontal center line. (Inherited from Infragistics.Documents.Excel.WorksheetShape)
Public PropertyFloorReturns a Infragistics.Documents.Excel.Charts.Wall object that allows the user to format the bottom wall of a 3-D chart. Read-only.  
Public PropertyGapDepthReturns or sets the gap depth in a 3-D chart, expressed as a percentage of the marker width. The value of this property must be between 0 and 500.  
Public PropertyGapWidthReturns or sets the distance between the data series in a bar chart, as a percentage of the marker width. The value of this property must be between 0 and 500.  
Public PropertyHeightPercentReturns or sets the height of a 3-D chart as a percentage of the chart width (between 5 and 500 percent).  
Public PropertyHighLowLinesReturns or sets a Infragistics.Documents.Excel.Charts.ChartHighLowLines instance which determines the appearance for a stock chart's high/low lines.  
Public PropertyLegendReturns or sets a Legend object which represents the legend for the chart.  
Public PropertyOutlineGets or sets the outline to use for the shape. (Inherited from Infragistics.Documents.Excel.WorksheetShape)
Public PropertyPerspectiveReturns or sets a value that represents the perspective for the 3-D chart view, expressed in degrees.  
Public PropertyPlotAreaReturns a PlotArea object that represents the plot area of a chart. Read-only.  
Public PropertyPlotVisibleOnlyTrue if only visible cells are plotted. False if both visible and hidden cells are plotted.  
Public PropertyPositioningModeGets or sets the way shapes will be repositioned in excel when cells before or within the shape are resized. (Inherited from Infragistics.Documents.Excel.WorksheetShape)
Public PropertyRightAngleAxesTrue if the chart axes are at right angles, independent of chart rotation or elevation. Applies only to 3-D line, column, and bar charts.  
Public PropertyRotationXReturns or sets the rotation of a 3-D chart view around the X-axis, expressed in degrees.  
Public PropertyRotationYReturns or sets the rotation of a 3-D chart view around the Y-axis, expressed in degrees.  
Public PropertySecondPlotSizeReturns or sets the size of the second plot area in a 'bar of pie' or 'pie of pie' chart, expressed as a percentage of the first plot area's size.  
Public PropertySeriesCollectionReturns the series collection (read-only)  
Public PropertySeriesLinesDetermines the fill and width for the lines which connect the first and second plot areas in a 'bar of pie' or 'pie of pie' chart.  
Public PropertySeriesOverlapDetermines the amount by which intersecting Infragistics.Documents.Excel.Charts.Series overlap, expressed as a percentage of the bar size.  
Public PropertyShapesGets the collection of shapes contained in the group. (Inherited from Infragistics.Documents.Excel.WorksheetShapeGroupBase)
Public PropertySheetOverridden. Gets the worksheet on which the shape resides.  
Public PropertySideWallReturns a Infragistics.Documents.Excel.Charts.Wall object that allows the user to format the side wall of a 3-D chart. Read-only.  
Public PropertyTopLeftCornerCellGets or sets the cell where the top-left corner of the shape resides. (Inherited from Infragistics.Documents.Excel.WorksheetShape)
Public PropertyTopLeftCornerPositionGets or sets the position in the WorksheetShape.TopLeftCornerCell of the shape's top-left corner, expressed in percentages. (Inherited from Infragistics.Documents.Excel.WorksheetShape)
Public PropertyUpDownBarsReturns or sets a Infragistics.Documents.Excel.Charts.UpDownBars instance which determines the appearance for a stock chart's up/down bars.  
Public PropertyVaryColorsReturns or sets a boolean value indicating whether the fill colors for series and data points are automatically selected by Excel.  
Public PropertyVisibleGets or sets the value indicating whether the shape is visible on the worksheet. (Inherited from Infragistics.Documents.Excel.WorksheetShape)
Public PropertyWallDefaultReturns a Infragistics.Documents.Excel.Charts.Wall object which represents the back and side walls, and floor of the chart. Applicable only for 3-D charts.  
Public PropertyWorksheetGets the worksheet on which the shape resides. (Inherited from Infragistics.Documents.Excel.WorksheetShape)
Public Methods
 NameDescription
Public MethodClearUnknownDataClears the cached unknown shape data which was read in from a parsed excel file. (Inherited from Infragistics.Documents.Excel.WorksheetShape)
Public MethodGetBoundsInTwipsOverloaded. Gets the bounds of the shape in twips (1/20th of a point). (Inherited from Infragistics.Documents.Excel.WorksheetShape)
Public MethodSetBoundsInTwipsOverloaded. Sets the bounds of the shape in twips (1/20th of a point). (Inherited from Infragistics.Documents.Excel.WorksheetShape)
Public MethodSetComboChartSourceDataSets the source data range for a combo chart.  
Public MethodSetSourceDataSets the source data range for the chart.  
See Also