Represents a chart.
Inheritance
Properties
Section titled "Properties"Shapes
Section titled "Shapes"Inherited from: WorksheetShapeGroupBase
Gets the collection of shapes contained in the group.
public WorksheetShapeCollection Shapes { get; }Inherited from: WorksheetShape
Gets or sets the fill to use in the background of the shape.
public ShapeFill Fill { get; set; }BottomRightCornerCell
Section titled "BottomRightCornerCell"Inherited from: WorksheetShape
Gets or sets the cell where the bottom-right corner of the shape resides.
public WorksheetCell BottomRightCornerCell { get; set; }BottomRightCornerPosition
Section titled "BottomRightCornerPosition"Inherited from: WorksheetShape
Gets or sets the position in the of the shape's bottom-right corner, expressed in percentages.
public Point BottomRightCornerPosition { get; set; }FlippedHorizontally
Section titled "FlippedHorizontally"Inherited from: WorksheetShape
Gets or sets the value which indicates whether the shape is flipped horizontally along the vertical center line.
public bool FlippedHorizontally { get; set; }FlippedVertically
Section titled "FlippedVertically"Inherited from: WorksheetShape
Gets or sets the value which indicates whether the shape is flipped vertically along the horizontal center line.
public bool FlippedVertically { get; set; }Outline
Section titled "Outline"Inherited from: WorksheetShape
Gets or sets the outline to use for the shape.
public ShapeOutline Outline { get; set; }PositioningMode
Section titled "PositioningMode"Inherited from: WorksheetShape
Gets or sets the way shapes will be repositioned in excel when cells before or within the shape are resized.
public ShapePositioningMode PositioningMode { get; set; }TopLeftCornerCell
Section titled "TopLeftCornerCell"Inherited from: WorksheetShape
Gets or sets the cell where the top-left corner of the shape resides.
public WorksheetCell TopLeftCornerCell { get; set; }TopLeftCornerPosition
Section titled "TopLeftCornerPosition"Inherited from: WorksheetShape
Gets or sets the position in the of the shape's top-left corner, expressed in percentages.
public Point TopLeftCornerPosition { get; set; }Visible
Section titled "Visible"Inherited from: WorksheetShape
Gets or sets the value indicating whether the shape is visible on the worksheet.
public bool Visible { get; set; }Worksheet
Section titled "Worksheet"Inherited from: WorksheetShape
Gets the worksheet on which the shape resides.
public Worksheet Worksheet { get; }AutoScaling
Section titled "AutoScaling"True if Microsoft Excel scales a 3-D chart so that it's closer in size to the equivalent 2-D chart. The property must be True
public bool AutoScaling { get; set; }AxisCollection
Section titled "AxisCollection"Returns the axis collection (read-only)
public AxisCollection AxisCollection { get; }BackWall
Section titled "BackWall"Returns a object that allows the user to format the back wall of a 3-D chart. Read-only.
public Wall BackWall { get; }BarShape
Section titled "BarShape"Returns or sets the shape of bars. Applicable only to 3D bar-type charts.
public BarShape? BarShape { get; set; }BarShapeResolved
Section titled "BarShapeResolved"Returns the resolved value of the property.
public BarShape BarShapeResolved { get; }ChartArea
Section titled "ChartArea"Returns a object that represents the complete chart area for the chart. Read-only.
public ChartArea ChartArea { get; }ChartTitle
Section titled "ChartTitle"Returns or sets an object.
public ChartTitle ChartTitle { get; set; }ChartType
Section titled "ChartType"Specifies the chart type.
public ChartType ChartType { get; set; }ComboChartGroups
Section titled "ComboChartGroups"Returns a collection of the instances associated with this chart.
public ComboChartGroupCollection ComboChartGroups { get; }DepthPercent
Section titled "DepthPercent"Returns or sets the depth of a 3-D chart as a percentage of the chart width (between 20 and 2000 percent).
public int DepthPercent { get; set; }DisplayBlanksAs
Section titled "DisplayBlanksAs"Returns or sets the way that blank cells are plotted on a chart.
public DisplayBlanksAs DisplayBlanksAs { get; set; }DoughnutHoleSize
Section titled "DoughnutHoleSize"Returns or sets the size of the hole in a doughnut chart, expressed as a percentage of the size of the encompassing circle.
public int DoughnutHoleSize { get; set; }DropLines
Section titled "DropLines"Returns or sets a instance which determines the appearance for a stock chart's drop lines.
public ChartDropLines DropLines { get; set; }FirstSliceAngle
Section titled "FirstSliceAngle"Returns 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 int FirstSliceAngle { get; set; }Floor
Section titled "Floor"Returns a object that allows the user to format the bottom wall of a 3-D chart. Read-only.
public Wall Floor { get; }GapDepth
Section titled "GapDepth"Returns 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 int GapDepth { get; set; }GapWidth
Section titled "GapWidth"Returns 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 int GapWidth { get; set; }HeightPercent
Section titled "HeightPercent"Returns or sets the height of a 3-D chart as a percentage of the chart width (between 5 and 500 percent).
public int HeightPercent { get; set; }HighLowLines
Section titled "HighLowLines"Returns or sets a instance which determines the appearance for a stock chart's high/low lines.
public ChartHighLowLines HighLowLines { get; set; }Legend
Section titled "Legend"Returns or sets a object which represents the legend for the chart.
public Legend Legend { get; set; }Perspective
Section titled "Perspective"Returns or sets a value that represents the perspective for the 3-D chart view, expressed in degrees.
public int Perspective { get; set; }PlotArea
Section titled "PlotArea"Returns a PlotArea object that represents the plot area of a chart. Read-only.
public PlotArea PlotArea { get; }PlotVisibleOnly
Section titled "PlotVisibleOnly"True if only visible cells are plotted. False if both visible and hidden cells are plotted.
public bool PlotVisibleOnly { get; set; }RightAngleAxes
Section titled "RightAngleAxes"True 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 bool RightAngleAxes { get; set; }RotationX
Section titled "RotationX"Returns or sets the rotation of a 3-D chart view around the X-axis, expressed in degrees.
public int RotationX { get; set; }RotationY
Section titled "RotationY"Returns or sets the rotation of a 3-D chart view around the Y-axis, expressed in degrees.
public int RotationY { get; set; }SecondPlotSize
Section titled "SecondPlotSize"Returns 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 int SecondPlotSize { get; set; }SeriesCollection
Section titled "SeriesCollection"Returns the series collection (read-only)
public SeriesCollection SeriesCollection { get; }SeriesLines
Section titled "SeriesLines"Determines the and for the lines which connect the first and second plot areas in a 'bar of pie' or 'pie of pie' chart.
public ChartSeriesLines SeriesLines { get; set; }SeriesOverlap
Section titled "SeriesOverlap"Determines the amount by which intersecting overlap, expressed as a percentage of the bar size.
public int SeriesOverlap { get; set; }Sheet
Section titled "Sheet"Gets the worksheet on which the shape resides.
public override Sheet Sheet { get; }SideWall
Section titled "SideWall"Returns a object that allows the user to format the side wall of a 3-D chart. Read-only.
public Wall SideWall { get; }UpDownBars
Section titled "UpDownBars"Returns or sets a instance which determines the appearance for a stock chart's up/down bars.
public UpDownBars UpDownBars { get; set; }VaryColors
Section titled "VaryColors"Returns or sets a boolean value indicating whether the fill colors for and are automatically selected by Excel.
public bool VaryColors { get; set; }WallDefault
Section titled "WallDefault"Returns a object which represents the back and side walls, and floor of the chart. Applicable only for 3-D charts.
public Wall WallDefault { get; }Methods
Section titled "Methods"ClearUnknownData()
Section titled "ClearUnknownData()"Inherited from: WorksheetShape
Clears the cached unknown shape data which was read in from a parsed excel file.
public virtual void ClearUnknownData()Returns any
CreatePredefinedShape(PredefinedShapeType)
Section titled "CreatePredefinedShape(PredefinedShapeType)"Inherited from: WorksheetShape
Creates a shape which is predefined in Microsoft Excel.
public static WorksheetShape CreatePredefinedShape(PredefinedShapeType shapeType)Parameters
- shapeType:
PredefinedShapeType
Returns any
GetBoundsInTwips()
Section titled "GetBoundsInTwips()"Inherited from: WorksheetShape
Gets the bounds of the shape in twips (1/20th of a point).
public virtual Rect GetBoundsInTwips()Returns any
GetBoundsInTwips(PositioningOptions)
Section titled "GetBoundsInTwips(PositioningOptions)"Inherited from: WorksheetShape
Gets the bounds of the shape in twips (1/20th of a point).
public virtual Rect GetBoundsInTwips(PositioningOptions options)Parameters
- options:
PositioningOptions
Returns any
SetBoundsInTwips(Sheet, Rect)
Section titled "SetBoundsInTwips(Sheet, Rect)"Inherited from: WorksheetShape
Sets the bounds of the shape in twips (1/20th of a point).
public void SetBoundsInTwips(Sheet sheet, Rect bounds)Parameters
- sheet:
Sheet - bounds:
Rect
Returns any
SetBoundsInTwips(Sheet, Rect, PositioningOptions)
Section titled "SetBoundsInTwips(Sheet, Rect, PositioningOptions)"Inherited from: WorksheetShape
Sets the bounds of the shape in twips (1/20th of a point).
public void SetBoundsInTwips(Sheet sheet, Rect bounds, PositioningOptions options)Parameters
- sheet:
Sheet - bounds:
Rect - options:
PositioningOptions
Returns any
SetComboChartSourceData(string, ChartType[], bool, CellReferenceMode?)
Section titled "SetComboChartSourceData(string, ChartType[], bool, CellReferenceMode?)"Sets the source data range for a combo chart.
public void SetComboChartSourceData(string dataRange, ChartType[] seriesChartTypes, bool plotByRows = false, CellReferenceMode? cellReferenceMode = null)Parameters
- dataRange:
string - seriesChartTypes:
ChartType[] - plotByRows:
bool - cellReferenceMode:
CellReferenceMode?
Returns any
SetSourceData(string, bool, CellReferenceMode?)
Section titled "SetSourceData(string, bool, CellReferenceMode?)"Sets the source data range for the chart.
public void SetSourceData(string dataRange, bool plotByRows = false, CellReferenceMode? cellReferenceMode = null)Parameters
- dataRange:
string - plotByRows:
bool - cellReferenceMode:
CellReferenceMode?