Class SheetChart

Represents a chart that is anchored to a worksheet.

Inheritance

object

SheetChart

ChartWithSeries<DS>

Implements

IWorksheetDrawingObject

ISheetDrawingObject

IDrawingObject

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: DRIT.Spreadsheet.Chart

Assembly: DRIT.Spreadsheet.dll

Syntax

public abstract class SheetChart : IWorksheetDrawingObject, ISheetDrawingObject, IDrawingObject

Remarks

Chart data and axes use the shared semantic model, while ownership and placement remain worksheet- or chartsheet-specific.

Constructors

SheetChart(Sheet)

Initializes a new SheetChart for the supplied workbook data.

Declaration

public SheetChart(Sheet sheet)

Parameters

Type	Name	Description
Sheet	sheet

Remarks

Chart data and axes use the shared semantic model, while ownership and placement remain worksheet- or chartsheet-specific.

Fields

autoTitleDeleted

Exposes the auto title deleted associated with SheetChart.

Declaration

public bool? autoTitleDeleted

Field Value

Type	Description
bool?	The auto title deleted returned by the operation.

Remarks

Chart data and axes use the shared semantic model, while ownership and placement remain worksheet- or chartsheet-specific.

Properties

AnchoredCell

Exposes the anchored cell associated with SheetChart.

Declaration

public Cell AnchoredCell { get; set; }

Property Value

Type	Description
Cell	The anchored cell returned by the operation.

Remarks

Chart data and axes use the shared semantic model, while ownership and placement remain worksheet- or chartsheet-specific.

Axes

Gets the axes manager providing unified access to all axes on the chart regardless of the concrete chart type.

Declaration

public AxesManager Axes { get; }

Property Value

Type	Description
AxesManager

Remarks

Chart data and axes use the shared semantic model, while ownership and placement remain worksheet- or chartsheet-specific.

BottomRightCell

Exposes the bottom right cell associated with SheetChart.

Declaration

public Cell BottomRightCell { get; }

Property Value

Type	Description
Cell	The bottom right cell returned by the operation.

Remarks

Chart data and axes use the shared semantic model, while ownership and placement remain worksheet- or chartsheet-specific.

ChartArea

Exposes the chart area associated with SheetChart.

Declaration

public ChartArea ChartArea { get; }

Property Value

Type	Description
ChartArea	The chart area returned by the operation.

Remarks

Chart data and axes use the shared semantic model, while ownership and placement remain worksheet- or chartsheet-specific.

ChartType

Exposes the chart type associated with SheetChart.

Declaration

public ChartType ChartType { get; set; }

Property Value

Type	Description
ChartType	The chart type returned by the operation.

Remarks

Chart data and axes use the shared semantic model, while ownership and placement remain worksheet- or chartsheet-specific.

Data

Gets the unified data container providing access to the chart's categories and series. Maps to c:chart/c:plotArea data content.

Declaration

public ChartData Data { get; }

Property Value

Type	Description
ChartData

Remarks

Chart data and axes use the shared semantic model, while ownership and placement remain worksheet- or chartsheet-specific.

DataSource

Exposes the data source associated with SheetChart.

Declaration

public string DataSource { get; set; }

Property Value

Type	Description
string	The data source returned by the operation.

Remarks

Chart data and axes use the shared semantic model, while ownership and placement remain worksheet- or chartsheet-specific.

HasRotation3D

Gets whether this chart has 3D rotation settings applied.

Declaration

public bool HasRotation3D { get; }

Property Value

Type	Description
bool

Remarks

Chart data and axes use the shared semantic model, while ownership and placement remain worksheet- or chartsheet-specific.

HiddenEmptyCellSettings

Exposes the hidden empty cell settings associated with SheetChart.

Declaration

public HiddenEmptyCellSettings HiddenEmptyCellSettings { get; }

Property Value

Type	Description
HiddenEmptyCellSettings	The hidden empty cell settings returned by the operation.

Remarks

Chart data and axes use the shared semantic model, while ownership and placement remain worksheet- or chartsheet-specific.

Id

Exposes the id associated with SheetChart.

Declaration

public int Id { get; set; }

Property Value

Type	Description
int	The id returned by the operation.

Remarks

Chart data and axes use the shared semantic model, while ownership and placement remain worksheet- or chartsheet-specific.

Legend

Specifies the legend of the chart.

Declaration

public Legend Legend { get; set; }

Property Value

Type	Description
Legend

Remarks

Chart data and axes use the shared semantic model, while ownership and placement remain worksheet- or chartsheet-specific.

Name

Exposes the name associated with SheetChart.

Declaration

public string Name { get; set; }

Property Value

Type	Description
string	The name returned by the operation.

Remarks

Chart data and axes use the shared semantic model, while ownership and placement remain worksheet- or chartsheet-specific.

ParentGroup

Exposes the parent group associated with SheetChart.

Declaration

public GroupShape ParentGroup { get; }

Property Value

Type	Description
GroupShape	The parent group returned by the operation.

Remarks

Chart data and axes use the shared semantic model, while ownership and placement remain worksheet- or chartsheet-specific.

PlotArea

Exposes the plot area associated with SheetChart.

Declaration

public PlotArea PlotArea { get; }

Property Value

Type	Description
PlotArea	The plot area returned by the operation.

Remarks

Chart data and axes use the shared semantic model, while ownership and placement remain worksheet- or chartsheet-specific.

Position

Exposes the position associated with SheetChart.

Declaration

public Position Position { get; }

Property Value

Type	Description
Position	The position returned by the operation.

Remarks

Chart data and axes use the shared semantic model, while ownership and placement remain worksheet- or chartsheet-specific.

Positioning

Exposes the positioning associated with SheetChart.

Declaration

public AnchorProperties Positioning { get; set; }

Property Value

Type	Description
AnchorProperties	The positioning returned by the operation.

Remarks

Chart data and axes use the shared semantic model, while ownership and placement remain worksheet- or chartsheet-specific.

Rotation3D

Specifies the 3D rotation settings for the chart. Maps to c:view3D. Use HasRotation3D to check whether rotation has been explicitly applied.

Declaration

public ChartWallThreeDRotation Rotation3D { get; set; }

Property Value

Type	Description
ChartWallThreeDRotation

Remarks

Chart data and axes use the shared semantic model, while ownership and placement remain worksheet- or chartsheet-specific.

RoundedCorners

Indicates whether the chart has rounded corners.

Declaration

public bool RoundedCorners { get; set; }

Property Value

Type	Description
bool

Remarks

Chart data and axes use the shared semantic model, while ownership and placement remain worksheet- or chartsheet-specific.

Sheet

Exposes the sheet associated with SheetChart.

Declaration

public Sheet Sheet { get; }

Property Value

Type	Description
Sheet	The sheet returned by the operation.

Remarks

Chart data and axes use the shared semantic model, while ownership and placement remain worksheet- or chartsheet-specific.

Size

Exposes the size associated with SheetChart.

Declaration

public Size Size { get; }

Property Value

Type	Description
Size	The size returned by the operation.

Remarks

Chart data and axes use the shared semantic model, while ownership and placement remain worksheet- or chartsheet-specific.

Title

Exposes the title associated with SheetChart.

Declaration

public Title Title { get; }

Property Value

Type	Description
Title	The title returned by the operation.

Remarks

Chart data and axes use the shared semantic model, while ownership and placement remain worksheet- or chartsheet-specific.

Usershapes

Gets the collection of shapes within a chart.

Declaration

public ShapeCollection Usershapes { get; }

Property Value

Type	Description
ShapeCollection

Remarks

Chart data and axes use the shared semantic model, while ownership and placement remain worksheet- or chartsheet-specific.

Workbook

Specifies the parent workbook.

Declaration

protected Workbook Workbook { get; set; }

Property Value

Type	Description
Workbook

Remarks

Chart data and axes use the shared semantic model, while ownership and placement remain worksheet- or chartsheet-specific.

Worksheet

Exposes the worksheet associated with SheetChart.

Declaration

public Worksheet Worksheet { get; }

Property Value

Type	Description
Worksheet	The worksheet returned by the operation.

Remarks

Chart data and axes use the shared semantic model, while ownership and placement remain worksheet- or chartsheet-specific.

Methods

AddLegend()

Creates and assigns a legend to the chart.

Declaration

public void AddLegend()

Remarks

Chart data and axes use the shared semantic model, while ownership and placement remain worksheet- or chartsheet-specific.

AddTitle()

Adds the supplied title to the SheetChart.

Declaration

public void AddTitle()

Remarks

Chart data and axes use the shared semantic model, while ownership and placement remain worksheet- or chartsheet-specific.

OnChartTypeSet()

Exposes the on chart type set associated with SheetChart.

Declaration

protected virtual void OnChartTypeSet()

Remarks

Chart data and axes use the shared semantic model, while ownership and placement remain worksheet- or chartsheet-specific.

Implements

IWorksheetDrawingObject

ISheetDrawingObject

IDrawingObject