Back to Devexpress

Chart Members

officefileapi-devexpress-dot-spreadsheet-dot-charts-dot-chart-dot-underscore-members.md

latest14.9 KB
Original Source

Chart Members

An embedded chart on a worksheet.

Properties

NameDescription
AlternativeTextGets or sets the descriptive (alternative) text for a drawing object. Inherited from Shape.
BottomRightCellGets or sets a cell where the bottom right corner of a floating object is located. Inherited from FloatingObject.
ChartTypeReturns the chart type. Inherited from ChartObject.
ColorPaletteReturns or specifies a color palette for the chart. Applies only to Excel 2016 charts. Inherited from ChartObject.
ConnectorFormatProvides access to the shape connector settings. Inherited from Shape.
DataTableProvides access to display settings for the chart data table. Inherited from ChartObject.
DecorativeGets or sets whether the shape is marked as decorative. Inherited from Shape.
FillProvides access to fill options for the specified drawing object. Inherited from ShapeFormatBase.
FontAllows you to change the text font for all chart elements. Inherited from ChartObject.
HeightGets or sets the height of the floating object. Inherited from FloatingObject.
HyperlinkGets the hyperlink associated with a drawing object (picture). Inherited from Shape.
IdGets the drawing object identifier. Inherited from Shape.
LeftGets or sets the distance from the left edge of the worksheet to the top left corner of the floating object. Inherited from FloatingObject.
LegendProvides access to a chart legend. Inherited from ChartObject.
LockAspectRatioGets or sets whether the floating object retains its original proportions after resizing. Inherited from FloatingObject.
NameGets or sets the name of the drawing object. Inherited from Shape.
OffsetXGets a distance from the top left corner of the floating to the left edge of the cell where the top left corner of the floating object is located. Inherited from FloatingObject.
OffsetYGets a distance from the top left corner of the floating object to the top edge of the cell where the top left corner of the floating object is located. Inherited from FloatingObject.
OptionsProvides access to various options available for the chart. Inherited from ChartObject.
OutlineProvides access to the options used to format an outline of the specified drawing object. Inherited from ShapeFormatBase.
ParentGroupRetrieves the group in which the current shape is contained. Inherited from Shape.
PlacementGets or sets the behavior of the floating object regarding the cells below. Inherited from FloatingObject.
PlotAreaProvides access to the chart’s plot area. Inherited from ChartObject.
PrimaryAxesProvides access to a collection of primary axes. Inherited from ChartObject.
RotationGets or sets the rotation of the drawing object, in degrees. Inherited from Shape.
SecondaryAxesProvides access to a collection of secondary axes. Inherited from ChartObject.
SeriesProvides access to the collection of Series objects. Inherited from ChartObject.
ShapeGeometryProvides access to the shape’s geometry options. Inherited from Shape.
ShapeTextProvides access to the shape’s text options. Inherited from Shape.
ShapeTypeReturns the type of the drawing object. Inherited from Shape.
StyleReturns or specifies the chart style. Inherited from ChartObject.
TitleGets the title of the chart. Inherited from ChartObject.
TopGets or sets the distance from the top edge of the worksheet to the top left corner of the floating object. Inherited from FloatingObject.
TopLeftCellGets or sets a cell where the top left corner of a floating object is located. Inherited from FloatingObject.
View3DProvides access to the display settings of three-dimensional charts. Inherited from ChartObject.
ViewsReturns a collection of chart views. Inherited from ChartObject.
WidthGets or sets the width of the floating object. Inherited from FloatingObject.
ZOrderPositionGets the position of the current drawing object in the z-order. Inherited from Shape.

Methods

NameDescription
ChangeType(ChartType)Changes the type of the chart. Inherited from ChartObject.
CopyTo(Worksheet)Creates a copy of the chart in another worksheet. Inherited from ChartObject.
Delete()Deletes a drawing object. Inherited from Shape.
ExportToImage()Saves the drawing object as an image. Inherited from Shape.
ExportToImage(Stream, ImageFileFormat)Saves the drawing object as an image in the specified format. Inherited from Shape.
ExportToImage(String, ImageFileFormat)Saves the drawing object as an image in the specified format. Inherited from Shape.
GetChildren()Retrieves the list of nested shapes and shape groups. Inherited from Shape.
GetDataRange()Returns a cell range containing chart data. Inherited from ChartObject.
GetImage()Converts the chart to an image. Inherited from ChartObject.
GetImage(Size)Converts the chart to an image of the specified size. Inherited from ChartObject.
IncrementRotation(Int32)Increments the rotation angle of the drawing object by the specified number of degrees. Inherited from Shape.
InsertHyperlink(String, Boolean)Associates a hyperlink with the drawing object. Inherited from Shape.
LoadStyle(Stream)Loads a custom style from the specified stream and applies it to the chart. Available only for Excel 2016 charts. Inherited from ChartObject.
LoadStyle(String)Loads a custom style from the specified XML file and applies it to the chart. Available only for Excel 2016 charts. Inherited from ChartObject.
LoadTemplate(Stream)Loads a custom chart style and formatting settings from the stream and applies it to the chart. Inherited from ChartObject.
Move(Single, Single)Moves a floating object by a specified offset. Inherited from FloatingObject.
MoveToNewChartSheet(String)Moves the current chart to a separate chart sheet. Inherited from ChartObject.
MoveToWorksheet(Worksheet)Moves a chart to the specified worksheet. Inherited from ChartObject.
RemoveHyperlink()Removes the hyperlink associated with the current drawing object. Inherited from Shape.
ResetToMatchStyle()Removes custom formatting of the chart element and applies default formatting based on the chart style. Inherited from ShapeFormat.
SelectData(CellRange, ChartDataDirection)Specifies the source data for the chart. Inherited from ChartObject.
SelectData(CellRange)Specifies the source data for the chart. Inherited from ChartObject.
SwitchRowColumn()Switches rows to columns in the chart data, plotting them on different axes. Inherited from ChartObject.

See Also

Chart Interface

DevExpress.Spreadsheet.Charts Namespace