Back to Devexpress

DevExpress.Spreadsheet.Charts Namespace

officefileapi-devexpress-dot-spreadsheet-0cc109c6.md

latest12.6 KB
Original Source

DevExpress.Spreadsheet.Charts Namespace

Contains interfaces and enumerations which implement the spreadsheet charting functionality.

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Classes

NameDescription
ChartDataData plotted on a chart.

Interfaces

NameDescription
AxisRepresents an axis on a chart.
AxisCollectionA collection that stores axes in the chart.
AxisScalingContains axis scaling options.
BoxAndWhiskerSeriesOptionsContains options for box and whisker data series.
ChartAn embedded chart on a worksheet.
ChartCollectionA collection of Chart objects in a worksheet.
ChartLineOptionsContains display settings for specific lines shown on a chart.
ChartObjectContains basic properties and methods for embedded charts and chart sheets.
ChartOptionsContains various options available for a chart.
ChartTextThe text displayed in the chart element.
ChartTitleA chart title.
ChartTitleOptionsContains common options for the chart and axis titles.
ChartViewConsolidates data series of the same type and contains series customization options.
ChartViewCollectionA collection of chart views in a chart.
DataLabelA data label on a point of the chart series.
DataLabelBaseContains basic data label options and serves as the base for the DataLabelOptions interface.
DataLabelCollectionA collection that stores customized data labels and data label options for a series in the chart.
DataLabelOptionsContains data label options.
DataPointSpecifies the appearance of the data point in a chart series.
DataPointCollectionA collection that stores custom settings for data points and data point options for the series in the chart.
DataTableOptionsContains display options for the chart data table.
DisplayUnitOptionsContains options used to specify the display units for the value axis.
ErrorBarsCollectionA collection of error bars for the series.
ErrorBarsOptionsContains options for a chart series error bar.
HistogramSeriesOptionsContains options for histogram and Pareto series.
LayoutOptionsSpecifies the exact position of the chart element.
LayoutPositionA container to hold a value and specify how it should be interpreted.
LegendA legend in a chart.
LegendEntryA single legend entry in a chart legend.
LegendEntryCollectionA collection that stores customized legend entries for a series in the chart.
MarkerRepresents a data marker displayed at each data point in the series on the line, scatter or radar chart.
NumberFormatOptionsAllows you to specify a number format used to display numeric values in chart elements (axis labels, data labels, and trendline labels).
PlotAreaThe chart’s background in which data series, axes, gridlines and data labels are displayed.
SeriesA data series in a chart.
SeriesCollectionA collection that stores data series in the chart.
SeriesLayoutOptionsContains series options for Excel 2016 charts.
ShapeFormatContains options used to format chart elements.
ShapeTextFormatContains options for a text displayed in a chart element.
SubtotalDataPointCollectionA collection of data points that are displayed as totals in a waterfall chart.
SurfaceOptionsContains formatting options for a particular surface of a 3-D chart.
TreemapSeriesOptionsContains options for treemap data series.
TrendlineA trendline in a chart that shows trends in the series data.
TrendlineCollectionA collection that stores the Trendline objects for the specified series.
TrendlineLabelA label displayed on a trendline.
UpDownBarsOptionsContains settings used to display up-down bars on a 2-D line or stock chart.
View3DOptionsContains display options for three-dimensional charts.
WaterfallSeriesOptionsContains options for waterfall data series.

Enums

NameDescription
AxisCrossPositionLists values used to specify the position of the crossing point where the value and category axes intersect.
AxisCrossTypeLists values that specify the intersection point for chart axes.
AxisGroupLists values used to specify the type of axis group for a series in a chart.
AxisLabelAlignmentLists values used to specify the text alignment for the category axis labels.
AxisOrientationLists values used to specify the orientation of the axis.
AxisPositionLists values that specify the axis position on a chart.
AxisTickLabelPositionLists values used to specify the position of axis labels.
AxisTickMarksLists values used to specify the position of the tick marks on the axis.
AxisTimeUnitsLists values used to specify the time units for the date axis.
AxisTypeLists values used to specify the type of the axis.
BarShapeLists shapes used to visualize a data point in 3D bar or column charts.
BubbleSizeRepresentsLists values used to specify what the bubble size represents on a bubble chart.
ChartColorPaletteLists color palettes for Microsoft® Excel® 2016 charts.
ChartDataDirectionLists values used to specify the direction in which data series are retrieved.
ChartStyleLists chart styles.
ChartTextTypeLists sources of the text displayed in a chart element.
ChartTrendlineTypeSpecifies how the trendline for a series data is calculated.
ChartTypeLists chart types.
DataLabelPositionLists values used to specify the position of data labels on the chart.
DisplayBlanksAsLists values used to specify how empty cells are displayed on a chart.
DisplayUnitTypeLists values that specify display units for the value axis.
ErrorBarDirectionLists values that indicate the error bar direction.
ErrorBarTypeLists values that indicate the error bar type.
ErrorBarValueTypeLists values that indicate the error value type.
HistogramBinTypeLists values that specify how to calculate bin intervals for a histogram series.
HistogramIntervalClosedSideLists values that specify the closed side of histogram bins.
HistogramOverflowTypeLists values that specify how to create the overflow and underflow bins on a histogram chart.
LayoutModeLists the possible interpretations of the Width and Height properties which specify the position of a chart element.
LayoutTargetSpecifies whether the plot area used to measure the layout should be inner or outer.
LegendPositionLists positions of the legend on a chart.
MarkerStyleLists values that specify the shape of markers which can be painted at each data point in the series on the line, scatter or radar chart and within the chart legend.
OfPieSplitTypeLists values used to specify the possible ways to split a Pie of Pie or Bar of Pie chart.
QuartileCalculationMethodLists values that specify the quartile calculation method for a box and whisker series.
ShapeTextDirectionLists values used to specify the text direction in a chart element.
TreemapParentLabelLayoutLists display options for parent labels in a treemap chart.