Back to Devexpress

ChartObject Members

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

latest5.7 KB
Original Source

ChartObject Members

Contains basic properties and methods for embedded charts and chart sheets.

Properties

NameDescription
ChartTypeReturns the chart type.
ColorPaletteReturns or specifies a color palette for the chart. Applies only to Excel 2016 charts.
DataTableProvides access to display settings for the chart data table.
FillProvides access to fill options for the specified drawing object. Inherited from ShapeFormatBase.
FontAllows you to change the text font for all chart elements.
LegendProvides access to a chart legend.
OptionsProvides access to various options available for the chart.
OutlineProvides access to the options used to format an outline of the specified drawing object. Inherited from ShapeFormatBase.
PlotAreaProvides access to the chart’s plot area.
PrimaryAxesProvides access to a collection of primary axes.
SecondaryAxesProvides access to a collection of secondary axes.
SeriesProvides access to the collection of Series objects.
StyleReturns or specifies the chart style.
TitleGets the title of the chart.
View3DProvides access to the display settings of three-dimensional charts.
ViewsReturns a collection of chart views.

Methods

NameDescription
ChangeType(ChartType)Changes the type of the chart.
CopyTo(Worksheet)Creates a copy of the chart in another worksheet.
GetDataRange()Returns a cell range containing chart data.
GetImage()Converts the chart to an image.
GetImage(Size)Converts the chart to an image of the specified size.
LoadStyle(Stream)Loads a custom style from the specified stream and applies it to the chart. Available only for Excel 2016 charts.
LoadStyle(String)Loads a custom style from the specified XML file and applies it to the chart. Available only for Excel 2016 charts.
LoadTemplate(Stream)Loads a custom chart style and formatting settings from the stream and applies it to the chart.
MoveToNewChartSheet(String)Moves the current chart to a separate chart sheet.
MoveToWorksheet(Worksheet)Moves a chart to the specified worksheet.
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.
SelectData(CellRange)Specifies the source data for the chart.
SwitchRowColumn()Switches rows to columns in the chart data, plotting them on different axes.

See Also

ChartObject Interface

DevExpress.Spreadsheet.Charts Namespace