Aspose::Slides::Charts Namespace Reference

Classes

class  AxesCompositionNotCombinableException
 Exception which thrown when axes composition of the series is not combinable with present axes composition in chart. More...
 
class  AxesManager
 Provides access to chart axes. More...
 
class  Axis
 Encapsulates the object that represents a chart's axis. More...
 
class  AxisFormat
 Represents chart format properties. More...
 
class  BaseChartValue
 
class  CannotCombine2DAnd3DChartsException
 Exception which thrown when trying to combine 2D and 3D chart types. More...
 
class  Chart
 Represents an graphic chart on a slide. More...
 
class  ChartCategory
 Represents chart categories. More...
 
class  ChartCategoryCollection
 Represents collection of ChartCategory More...
 
class  ChartCategoryLevelsManager
 Managed container of the values of the chart category levels. More...
 
class  ChartCellCollection
 Represents collection of a cells with data. More...
 
class  ChartData
 Represents data used for a chart plotting. More...
 
class  ChartDataCell
 Represents cell for chart data. More...
 
class  ChartDataPoint
 Represents series data point. More...
 
class  ChartDataPointCollection
 Represents collection of a series data point. More...
 
class  ChartDataWorkbook
 Provides access to embedded Excel workbook More...
 
class  ChartDataWorksheet
 Represents worksheet associated with IChartDataCell More...
 
class  ChartLinesFormat
 Represents gridlines format properties. More...
 
class  ChartPlotArea
 Represents rectangle where chart should be plotted. More...
 
class  ChartPortionFormat
 This class contains the chart portion formatting properties used in charts. Unlike PortionFormatEffectiveData, all properties of this class are writeable. More...
 
class  ChartSeries
 Represents a chart series. More...
 
class  ChartSeriesCollection
 Represents collection of ChartSeries More...
 
class  ChartSeriesGroup
 Represents group of series. More...
 
class  ChartTextFormat
 Specifies default text formatting for chart text elements. More...
 
class  ChartTitle
 Represents chart title properties. More...
 
class  ChartTypeCharacterizer
 Helper for getting additional information about charts and series by its ChartType. More...
 
class  ChartWall
 Represents walls on 3d charts. More...
 
class  DataLabel
 Represents a series labels. More...
 
class  DataLabelCollection
 Represents a series labels. More...
 
class  DataLabelFormat
 Represents formatting options for DataLabel. More...
 
class  DataSourceTypeForErrorBarsCustomValues
 Specifies types of values in ChartDataPoint.ErrorBarsCustomValues properties list More...
 
class  DataTable
 Represents data table properties. More...
 
class  DoubleChartValue
 Represent double value which can be stored in pptx presentation document in two ways: 1) in cell/cells of workbook related to chart; 2) as literal value. More...
 
class  ErrorBarsCustomValues
 Specifies the errors bar values. It shall be used only when the Error bars value type is Custom. More...
 
class  ErrorBarsFormat
 Represents error bars of chart series. ErrorBars custom values are in IChartDataPointCollection (in IChartDataPoint::ErrorBarsCustomValues property). More...
 
class  Format
 Represents chart format properties. More...
 
class  IActualLayout
 Specifies actual position of a chart element. More...
 
class  IAxesManager
 Provides access to chart axes. More...
 
class  IAxis
 Encapsulates the object that represents a chart's axis. More...
 
class  IAxisFormat
 Represents chart format properties. More...
 
class  IBaseChartValue
 
class  IChart
 
class  IChartCategory
 Represents chart categories. More...
 
class  IChartCategoryCollection
 Represents collection of IChartCategory More...
 
class  IChartCategoryLevelsManager
 Managed container of the values of the chart category levels. More...
 
class  IChartCellCollection
 Represents collection of a cells with data. More...
 
class  IChartComponent
 Represents a component of a chart. More...
 
class  IChartData
 Represents data used for a chart plotting. More...
 
class  IChartDataCell
 Represents cell for chart data. More...
 
class  IChartDataPoint
 Represents series data point. More...
 
class  IChartDataPointCollection
 Represents collection of a series data point. More...
 
class  IChartDataWorkbook
 Provides access to embedded Excel workbook More...
 
class  IChartDataWorksheet
 Represents worksheet associated with IChartDataCell More...
 
class  IChartLinesFormat
 Represents gridlines format properties. More...
 
class  IChartParagraphFormat
 
class  IChartPlotArea
 Represents chart title properties. More...
 
class  IChartPortionFormat
 
class  IChartSeries
 Represents a chart series. More...
 
class  IChartSeriesCollection
 Represents collection of IChartSeries More...
 
class  IChartSeriesGroup
 Represents group of series. More...
 
class  IChartSeriesGroupCollection
 Represents the coleection of groups of combinable series. More...
 
class  IChartSeriesReadonlyCollection
 Represents a readonly collection of IChartSeries More...
 
class  IChartTextBlockFormat
 Represents formatting properties for chart text elements. More...
 
class  IChartTextFormat
 Chart operate with restricted set of text format properties. IChartTextFormat, IChartTextBlockFormat, IChartParagraphFormat, IChartPortionFormat interfaces describe this restricted set. More...
 
class  IChartTitle
 Represents chart title properties. More...
 
class  IChartWall
 Represents walls on 3d charts. More...
 
class  IDataLabel
 Represents a series labels. More...
 
class  IDataLabelCollection
 Represents a series labels. More...
 
class  IDataLabelFormat
 
class  IDataSourceTypeForErrorBarsCustomValues
 Specifies types of values in ChartDataPoint.ErrorBarsCustomValues properties list More...
 
class  IDataTable
 Represents data table properties. More...
 
class  IDoubleChartValue
 
class  IErrorBarsCustomValues
 Specifies the errors bar values. It shall be used only when the Error bars value type is Custom. More...
 
class  IErrorBarsFormat
 Represents error bars of chart series. ErrorBars custom values are in IChartDataPointCollection (in IChartDataPoint::ErrorBarsCustomValues property). More...
 
class  IFormat
 Represents chart format properties. More...
 
class  IFormattedTextContainer
 
class  ILayoutable
 Specifies the exact position of a chart element. More...
 
class  ILegend
 Represents chart's legend properties. More...
 
class  ILegendEntryCollection
 
class  ILegendEntryProperties
 
class  IMarker
 
class  IMultipleCellChartValue
 
class  IOverridableText
 
class  IPieSplitCustomPointCollection
 Represents a collection of points that shall be drawn in the second pie or bar on a bar-of-pie or pie-of-pie chart with a custom split. More...
 
class  IRotation3D
 Represents 3D rotation of a chart. More...
 
class  ISingleCellChartValue
 
class  IStringChartValue
 Represent string value which can be stored in pptx presentation document in two ways: 1) in cell/cells of workbook related to chart; 2) as literal value. More...
 
class  IStringOrDoubleChartValue
 Represent string or double value which can be stored in pptx presentation document in two ways: 1) in cell/cells of workbook related to chart; 2) as literal value. More...
 
class  ITrendline
 Class represents trend line of chart series More...
 
class  ITrendlineCollection
 Represents a collection of TrendlineEx More...
 
class  IUpDownBarsManager
 Provide access to up/down bars of Line- or Stock-chart. More...
 
class  Legend
 Represents chart's legend properties. More...
 
class  LegendEntryCollection
 
class  LegendEntryProperties
 
class  ListOfChartDataItems
 
class  Marker
 
class  PieSplitCustomPointCollection
 Represents a collection of points for splitting point in a bar-of-pie or pie-of-pie chart with a custom split. More...
 
class  Rotation3D
 Represents 3D rotation of a chart. More...
 
class  StringChartValue
 Represent string value which can be stored in pptx presentation document in two ways: 1) in cell/cells of workbook related to chart; 2) as literal value. More...
 
class  StringOrDoubleChartValue
 Represent string or double value which can be stored in pptx presentation document in two ways: 1) in cell/cells of workbook related to chart; 2) as literal value. More...
 
class  Trendline
 Class represents trend line of chart series More...
 
class  TrendlineCollection
 Represents a collection of Trendline More...
 
class  UpDownBarsManager
 Provide access to up/down bars of Line- or Stock-chart. More...
 

Enumerations

enum  AxisAggregationType { AxisAggregationType::ByCategory, AxisAggregationType::Automatic, AxisAggregationType::ByBinWidth, AxisAggregationType::ByNumberOfBins }
 Represents aggregation type of category axis. Used with Histogram or HistogramPareto series only. More...
 
enum  AxisPositionType { AxisPositionType::Bottom = 0, AxisPositionType::Left, AxisPositionType::Right, AxisPositionType::Top }
 Determines a position of axis. More...
 
enum  CategoryAxisType { CategoryAxisType::Text, CategoryAxisType::Date }
 Represents a type of a category axis. More...
 
enum  ChartDataSourceType { ChartDataSourceType::InternalWorkbook, ChartDataSourceType::ExternalWorkbook }
 Represents a type of data source of the chart More...
 
enum  ChartShapeType {
  ChartShapeType::NotDefined = static_cast<int32_t>(-1), ChartShapeType::Box = 0, ChartShapeType::Cone, ChartShapeType::ConeToMax,
  ChartShapeType::Cylinder, ChartShapeType::Pyramid, ChartShapeType::PyramidToMaximum
}
 Represents a shape of chart. More...
 
enum  ChartType {
  ChartType::ClusteredColumn = 0, ChartType::StackedColumn, ChartType::PercentsStackedColumn, ChartType::ClusteredColumn3D,
  ChartType::StackedColumn3D, ChartType::PercentsStackedColumn3D, ChartType::Column3D, ChartType::ClusteredCylinder,
  ChartType::StackedCylinder, ChartType::PercentsStackedCylinder, ChartType::Cylinder3D, ChartType::ClusteredCone,
  ChartType::StackedCone, ChartType::PercentsStackedCone, ChartType::Cone3D, ChartType::ClusteredPyramid,
  ChartType::StackedPyramid, ChartType::PercentsStackedPyramid, ChartType::Pyramid3D, ChartType::Line,
  ChartType::StackedLine, ChartType::PercentsStackedLine, ChartType::LineWithMarkers, ChartType::StackedLineWithMarkers,
  ChartType::PercentsStackedLineWithMarkers, ChartType::Line3D, ChartType::Pie, ChartType::Pie3D,
  ChartType::PieOfPie, ChartType::ExplodedPie, ChartType::ExplodedPie3D, ChartType::BarOfPie,
  ChartType::PercentsStackedBar, ChartType::ClusteredBar3D, ChartType::ClusteredBar, ChartType::StackedBar,
  ChartType::StackedBar3D, ChartType::PercentsStackedBar3D, ChartType::ClusteredHorizontalCylinder, ChartType::StackedHorizontalCylinder,
  ChartType::PercentsStackedHorizontalCylinder, ChartType::ClusteredHorizontalCone, ChartType::StackedHorizontalCone, ChartType::PercentsStackedHorizontalCone,
  ChartType::ClusteredHorizontalPyramid, ChartType::StackedHorizontalPyramid, ChartType::PercentsStackedHorizontalPyramid, ChartType::Area,
  ChartType::StackedArea, ChartType::PercentsStackedArea, ChartType::Area3D, ChartType::StackedArea3D,
  ChartType::PercentsStackedArea3D, ChartType::ScatterWithMarkers, ChartType::ScatterWithSmoothLinesAndMarkers, ChartType::ScatterWithSmoothLines,
  ChartType::ScatterWithStraightLinesAndMarkers, ChartType::ScatterWithStraightLines, ChartType::HighLowClose, ChartType::OpenHighLowClose,
  ChartType::VolumeHighLowClose, ChartType::VolumeOpenHighLowClose, ChartType::Surface3D, ChartType::WireframeSurface3D,
  ChartType::Contour, ChartType::WireframeContour, ChartType::Doughnut, ChartType::ExplodedDoughnut,
  ChartType::Bubble, ChartType::BubbleWith3D, ChartType::Radar, ChartType::RadarWithMarkers,
  ChartType::FilledRadar, ChartType::SeriesOfMixedTypes, ChartType::Treemap, ChartType::Sunburst,
  ChartType::Histogram, ChartType::ParetoLine, ChartType::BoxAndWhisker, ChartType::Waterfall,
  ChartType::Funnel
}
 Represents a type of chart. More...
 
enum  CombinableSeriesTypesGroup {
  CombinableSeriesTypesGroup::AreaChart_Area = 4, CombinableSeriesTypesGroup::AreaChart_PercentsStackedArea = 5, CombinableSeriesTypesGroup::AreaChart_StackedArea = 6, CombinableSeriesTypesGroup::AreaChart_Area3D = 24,
  CombinableSeriesTypesGroup::AreaChart_StackedArea3D = 25, CombinableSeriesTypesGroup::AreaChart_PercentsStackedArea3D = 26, CombinableSeriesTypesGroup::LineChart_Line = 13, CombinableSeriesTypesGroup::LineChart_StackedLine = 14,
  CombinableSeriesTypesGroup::LineChart_PercentsStackedLine = 15, CombinableSeriesTypesGroup::Line3DChart = 27, CombinableSeriesTypesGroup::StockHighLowClose = 18, CombinableSeriesTypesGroup::StockOpenHighLowClose = 19,
  CombinableSeriesTypesGroup::StockVolumeHighLowClose = 20, CombinableSeriesTypesGroup::StockVolumeOpenHighLowClose = 21, CombinableSeriesTypesGroup::RadarChart = 16, CombinableSeriesTypesGroup::FilledRadarChart = 17,
  CombinableSeriesTypesGroup::ScatterStraightMarker = 22, CombinableSeriesTypesGroup::ScatterSmoothMarker = 23, CombinableSeriesTypesGroup::PieChart = 3, CombinableSeriesTypesGroup::Pie3DChart = 28,
  CombinableSeriesTypesGroup::DoughnutChart = 2, CombinableSeriesTypesGroup::BarChart_VertClustered = 10, CombinableSeriesTypesGroup::BarChart_VertStacked = 11, CombinableSeriesTypesGroup::BarChart_VertPercentsStacked = 12,
  CombinableSeriesTypesGroup::BarChart_HorizClustered = 7, CombinableSeriesTypesGroup::BarChart_HorizStacked = 8, CombinableSeriesTypesGroup::BarChart_HorizPercentsStacked = 9, CombinableSeriesTypesGroup::Bar3DChart_Vert = 29,
  CombinableSeriesTypesGroup::Bar3DChart_VertClustered = 30, CombinableSeriesTypesGroup::Bar3DChart_VertPercentsStackedColumn3D = 31, CombinableSeriesTypesGroup::Bar3DChart_VertPercentsStackedCone = 32, CombinableSeriesTypesGroup::Bar3DChart_VertPercentsStackedCylinder = 33,
  CombinableSeriesTypesGroup::Bar3DChart_VertPercentsStackedPyramid = 34, CombinableSeriesTypesGroup::Bar3DChart_VertStackedColumn3D = 35, CombinableSeriesTypesGroup::Bar3DChart_VertStackedCone = 36, CombinableSeriesTypesGroup::Bar3DChart_VertStackedCylinder = 37,
  CombinableSeriesTypesGroup::Bar3DChart_VertStackedPyramid = 38, CombinableSeriesTypesGroup::Bar3DChart_HorizClustered = 39, CombinableSeriesTypesGroup::Bar3DChart_HorizStackedBar3D = 40, CombinableSeriesTypesGroup::Bar3DChart_HorizStackedCone = 41,
  CombinableSeriesTypesGroup::Bar3DChart_HorizStackedCylinder = 42, CombinableSeriesTypesGroup::Bar3DChart_HorizStackedPyramid = 43, CombinableSeriesTypesGroup::Bar3DChart_HorizPercentsStackedBar3D = 44, CombinableSeriesTypesGroup::Bar3DChart_HorizPercentsStackedCone = 45,
  CombinableSeriesTypesGroup::Bar3DChart_HorizPercentsStackedCylinder = 46, CombinableSeriesTypesGroup::Bar3DChart_HorizPercentsStackedPyramid = 47, CombinableSeriesTypesGroup::BarOfPieChart = 0, CombinableSeriesTypesGroup::PieOfPieChart = 1,
  CombinableSeriesTypesGroup::SurfaceChart_Contour = 48, CombinableSeriesTypesGroup::SurfaceChart_WireframeContour = 49, CombinableSeriesTypesGroup::SurfaceChart_Surface3D = 50, CombinableSeriesTypesGroup::SurfaceChart_WireframeSurface3D = 51,
  CombinableSeriesTypesGroup::BubbleChart = 52, CombinableSeriesTypesGroup::HistogramChart = 53, CombinableSeriesTypesGroup::ParetoLineChart = 54, CombinableSeriesTypesGroup::BoxAndWhiskerChart = 55,
  CombinableSeriesTypesGroup::WaterfallChart = 56, CombinableSeriesTypesGroup::FunnelChart = 57, CombinableSeriesTypesGroup::TreemapChart = 58, CombinableSeriesTypesGroup::SunburstChart = 60
}
 Enumeration of groups of combinable series types. Each element relates to group of types of chart series that can persist simultaneously in one ChartSeriesGroup. For example: ChartType.PercentsStackedArea series cannot be simultaneously with ChartType.StackedArea series in one ChartSeriesGroup. But two or more ChartType.PercentsStackedArea can be in one ChartSeriesGroup simultaneously (CombinableSeriesTypesGroup.AreaChart_PercentsStackedArea). And ChartType.Line series can be with ChartType.LineWithMarkers series simultaneously in one CombinableSeriesTypesGroup.LineChart_Line ChartSeriesGroup. More...
 
enum  CrossesType { CrossesType::AxisCrossesAtZero = 0, CrossesType::Maximum, CrossesType::Custom }
 Determines where axis will cross. More...
 
enum  DataSourceType { DataSourceType::Worksheet, DataSourceType::StringLiterals, DataSourceType::DoubleLiterals }
 Data source types. More...
 
enum  DisplayBlanksAsType { DisplayBlanksAsType::Gap, DisplayBlanksAsType::Span, DisplayBlanksAsType::Zero }
 Determines how missing data will be displayed. More...
 
enum  DisplayUnitType {
  DisplayUnitType::None = 0, DisplayUnitType::Hundreds, DisplayUnitType::Thousands, DisplayUnitType::TenThousands,
  DisplayUnitType::HundredThousands, DisplayUnitType::Millions, DisplayUnitType::TenMillions, DisplayUnitType::HundredMillions,
  DisplayUnitType::Billions, DisplayUnitType::Trillions, DisplayUnitType::CustomValue
}
 Determines multiplicity of the displayed data. More...
 
enum  ErrorBarType { ErrorBarType::Both, ErrorBarType::Minus, ErrorBarType::Plus }
 Represents type of error bar More...
 
enum  ErrorBarValueType {
  ErrorBarValueType::Custom, ErrorBarValueType::Fixed, ErrorBarValueType::Percentage, ErrorBarValueType::StandardDeviation,
  ErrorBarValueType::StandardError
}
 Represents type of error bar value More...
 
enum  LegendDataLabelPosition {
  LegendDataLabelPosition::NotDefined = static_cast<int32_t>(-1), LegendDataLabelPosition::Bottom, LegendDataLabelPosition::BestFit, LegendDataLabelPosition::Center,
  LegendDataLabelPosition::InsideBase, LegendDataLabelPosition::InsideEnd, LegendDataLabelPosition::Left, LegendDataLabelPosition::OutsideEnd,
  LegendDataLabelPosition::Right, LegendDataLabelPosition::Top
}
 Determines position of data labels. More...
 
enum  LegendPositionType {
  LegendPositionType::Bottom = 0, LegendPositionType::Left, LegendPositionType::Right, LegendPositionType::Top,
  LegendPositionType::TopRight
}
 Determines a position of legend on a chart. More...
 
enum  MarkerStyleType {
  MarkerStyleType::NotDefined = static_cast<int32_t>(-1), MarkerStyleType::Circle, MarkerStyleType::Dash, MarkerStyleType::Diamond,
  MarkerStyleType::Dot, MarkerStyleType::None, MarkerStyleType::Picture, MarkerStyleType::Plus,
  MarkerStyleType::Square, MarkerStyleType::Star, MarkerStyleType::Triangle, MarkerStyleType::X
}
 Determines form of marker on chart's data point. More...
 
enum  ParentLabelLayoutType { ParentLabelLayoutType::Banner, ParentLabelLayoutType::None, ParentLabelLayoutType::Overlapping }
 Represents layout of category data labels. Used with Treemap series only. More...
 
enum  PictureType { PictureType::NotDefined = static_cast<int32_t>(-1), PictureType::Stack, PictureType::StackScale, PictureType::Stretch }
 Determines mode of bar picture filling. More...
 
enum  PieSplitType {
  PieSplitType::Default = 0, PieSplitType::Custom, PieSplitType::ByPercentage, PieSplitType::ByPos,
  PieSplitType::ByValue
}
 Represents a type of splitting points in the second pie or bar on a pie-of-pie or bar-of-pie chart. More...
 
enum  QuartileMethodType { QuartileMethodType::Exclusive, QuartileMethodType::Inclusive }
 Returns type of quartile method More...
 
enum  StyleType {
  StyleType::Style1 = 0, StyleType::Style2, StyleType::Style3, StyleType::Style4,
  StyleType::Style5, StyleType::Style6, StyleType::Style7, StyleType::Style8,
  StyleType::Style9, StyleType::Style10, StyleType::Style11, StyleType::Style12,
  StyleType::Style13, StyleType::Style14, StyleType::Style15, StyleType::Style16,
  StyleType::Style17, StyleType::Style18, StyleType::Style19, StyleType::Style20,
  StyleType::Style21, StyleType::Style22, StyleType::Style23, StyleType::Style24,
  StyleType::Style25, StyleType::Style26, StyleType::Style27, StyleType::Style28,
  StyleType::Style29, StyleType::Style30, StyleType::Style31, StyleType::Style32,
  StyleType::Style33, StyleType::Style34, StyleType::Style35, StyleType::Style36,
  StyleType::Style37, StyleType::Style38, StyleType::Style39, StyleType::Style40,
  StyleType::Style41, StyleType::Style42, StyleType::Style43, StyleType::Style44,
  StyleType::Style45, StyleType::Style46, StyleType::Style47, StyleType::Style48
}
 Represents chart style. More...
 
enum  TickLabelPositionType { TickLabelPositionType::High = 0, TickLabelPositionType::Low, TickLabelPositionType::NextTo, TickLabelPositionType::None }
 Represents the position type of tick-mark labels on the specified axis. More...
 
enum  TickMarkType { TickMarkType::Cross = 0, TickMarkType::Inside, TickMarkType::None, TickMarkType::Outside }
 Represents the tick mark type for the specified axis. More...
 
enum  TimeUnitType { TimeUnitType::Days = 0, TimeUnitType::Months, TimeUnitType::Years }
 Represents the base unit for the category axis More...
 
enum  TrendlineType {
  TrendlineType::Exponential, TrendlineType::Linear, TrendlineType::Logarithmic, TrendlineType::MovingAverage,
  TrendlineType::Polynomial, TrendlineType::Power
}
 Represents type of trend line More...
 

Enumeration Type Documentation

◆ AxisAggregationType

Represents aggregation type of category axis. Used with Histogram or HistogramPareto series only.

Enumerator
ByCategory 

Aggregate by categories

Automatic 

Aggregate categories automatically.

ByBinWidth 

Aggregate categories by bin width. Property IAxis.BinWidth must be setted.

ByNumberOfBins 

Aggregate categories by number of bins. Property IAxis.NumberOfBins must be setted.

◆ AxisPositionType

Determines a position of axis.

Enumerator
Bottom 

Specifies that the axis shall be displayed at the bottom of the plot area.

Left 

Specifies that the axis shall be displayed at the left of the plot area.

Right 

Specifies that the axis shall be displayed at the right of the plot area.

Top 

Specifies that the axis shall be displayed at the top of the plot area.

◆ CategoryAxisType

Represents a type of a category axis.

Enumerator
Text 

Specifies category axis is a text axis.

Date 

Specifies category axis is a date axis.

◆ ChartDataSourceType

Represents a type of data source of the chart

Enumerator
InternalWorkbook 

Internal data source.

ExternalWorkbook 

External data source.

◆ ChartShapeType

Represents a shape of chart.

Enumerator
NotDefined 

Chart shape is not defined.

Box 

Specifies the chart shall be drawn with a box shape.

Cone 

Specifies the chart shall be drawn as a cone, with the base of the cone on the floor and the point of the cone at the top of the data marker.

ConeToMax 

Specifies the chart shall be drawn with truncated cones such that the point of the cone would be the maximum data value.

Cylinder 

Specifies the chart shall be drawn as a cylinder.

Pyramid 

Specifies the chart shall be drawn as a rectangular pyramid, with the base of the pyramid on the floor and the point of the pyramid at the top of the data marker.

PyramidToMaximum 

Specifies the chart shall be drawn with truncated cones such that the point of the cone would be the maximum data value.

◆ ChartType

Represents a type of chart.

Enumerator
ClusteredColumn 

Represents Clustered Column Chart.

StackedColumn 

Represents Stacked Column Chart.

PercentsStackedColumn 

Represents 100% Stacked Column Chart.

ClusteredColumn3D 

Represents 3D Colustered Column Chart.

StackedColumn3D 

Represents 3D Stacked Column Chart.

PercentsStackedColumn3D 

Represents 3D 100% Stacked Column Chart.

Column3D 

Represents 3D Column Chart.

ClusteredCylinder 

Represents Cylinder Chart.

StackedCylinder 

Represents Stacked Cylinder Chart.

PercentsStackedCylinder 

Represents 100% Stacked Cylinder Chart.

Cylinder3D 

Represents 3D Cylindrical Column Chart.

ClusteredCone 

Represents Cone Chart.

StackedCone 

Represents Stacked Cone Chart.

PercentsStackedCone 

Represents 100% Stacked Cone Chart.

Cone3D 

Represents 3D Conical Column Chart.

ClusteredPyramid 

Represents Pyramid Chart.

StackedPyramid 

Represents Stacked Pyramid Chart.

PercentsStackedPyramid 

Represents 100% Stacked Pyramid Chart.

Pyramid3D 

Represents 3D Pyramid Column Chart.

Line 

Represents Line Chart.

StackedLine 

Represents Stacked Line Chart.

PercentsStackedLine 

Represents 100% Stacked Line Chart.

LineWithMarkers 

Represents Line Chart with data markers.

StackedLineWithMarkers 

Represents Stacked Line Chart with data markers.

PercentsStackedLineWithMarkers 

Represents 100% Stacked Line Chart with data markers.

Line3D 

Represents 3D Line Chart.

Pie 

Represents Pie Chart.

Pie3D 

Represents 3D Pie Chart.

PieOfPie 

Represents Pie of Pie Chart.

ExplodedPie 

Represents Exploded Pie Chart.

ExplodedPie3D 

Represents 3D Exploded Pie Chart.

BarOfPie 

Represents Bar of Pie Chart.

PercentsStackedBar 

Represents 100% Stacked Bar Chart.

ClusteredBar3D 

Represents 3D Colustered Bar Chart.

ClusteredBar 

Represents Clustered Bar Chart.

StackedBar 

Represents Stacked Bar Chart.

StackedBar3D 

Represents 3D Stacked Bar Chart.

PercentsStackedBar3D 

Represents 3D 100% Stacked Bar Chart.

ClusteredHorizontalCylinder 

Represents Cylindrical Bar Chart.

StackedHorizontalCylinder 

Represents Stacked Cylindrical Bar Chart.

PercentsStackedHorizontalCylinder 

Represents 100% Stacked Cylindrical Bar Chart.

ClusteredHorizontalCone 

Represents Conical Bar Chart.

StackedHorizontalCone 

Represents Stacked Conical Bar Chart.

PercentsStackedHorizontalCone 

Represents 100% Stacked Conical Bar Chart.

ClusteredHorizontalPyramid 

Represents Pyramid Bar Chart.

StackedHorizontalPyramid 

Represents Stacked Pyramid Bar Chart.

PercentsStackedHorizontalPyramid 

Represents 100% Stacked Pyramid Bar Chart.

Area 

Represents Area Chart.

StackedArea 

Represents Stacked Area Chart.

PercentsStackedArea 

Represents 100% Stacked Area Chart.

Area3D 

Represents 3D Area Chart.

StackedArea3D 

Represents 3D Stacked Area Chart.

PercentsStackedArea3D 

Represents 3D 100% Stacked Area Chart.

ScatterWithMarkers 

Represents Scatter Chart.

ScatterWithSmoothLinesAndMarkers 

Represents Scatter Chart connected by curves, with data markers.

ScatterWithSmoothLines 

Represents Scatter Chart connected by curves, without data markers.

ScatterWithStraightLinesAndMarkers 

Represents Scatter Chart connected by lines, with data markers.

ScatterWithStraightLines 

Represents Scatter Chart connected by lines, without data markers.

HighLowClose 

Represents High-Low-Close Stock Chart.

OpenHighLowClose 

Represents Open-High-Low-Close Stock Chart.

VolumeHighLowClose 

Represents Volume-High-Low-Close Stock Chart.

VolumeOpenHighLowClose 

Represents Volume-Open-High-Low-Close Stock Chart.

Surface3D 

Represents 3D Surface Chart.

WireframeSurface3D 

Represents Wireframe 3D Surface Chart.

Contour 

Represents Contour Chart.

WireframeContour 

Represents Wireframe Contour Chart.

Doughnut 

Represents Doughnut Chart.

ExplodedDoughnut 

Represents Exploded Doughnut Chart.

Bubble 

Represents Bubble Chart.

BubbleWith3D 

Represents 3D Bubble Chart.

Radar 

Represents Radar Chart.

RadarWithMarkers 

Represents Radar Chart with data markers.

FilledRadar 

Represents Filled Radar Chart.

SeriesOfMixedTypes 

This value only can be returned by ChartEx.Type property. It mean that chart has series of mixed types.

Treemap 

Represents Treemap chart.

Sunburst 

Represents Sunburst chart.

Histogram 

Represents Histogram chart.

ParetoLine 

Represents Pareto line series type (Histogram Pareto chart).

BoxAndWhisker 

Represents BoxAndWhisker chart.

Waterfall 

Represents Waterfall chart.

Funnel 

Represents Funnel chart.

◆ CombinableSeriesTypesGroup

Enumeration of groups of combinable series types. Each element relates to group of types of chart series that can persist simultaneously in one ChartSeriesGroup. For example: ChartType.PercentsStackedArea series cannot be simultaneously with ChartType.StackedArea series in one ChartSeriesGroup. But two or more ChartType.PercentsStackedArea can be in one ChartSeriesGroup simultaneously (CombinableSeriesTypesGroup.AreaChart_PercentsStackedArea). And ChartType.Line series can be with ChartType.LineWithMarkers series simultaneously in one CombinableSeriesTypesGroup.LineChart_Line ChartSeriesGroup.

Enumerator
AreaChart_Area 

Groups this set of series types: { ChartType.Area }

AreaChart_PercentsStackedArea 

Groups this set of series types: { ChartType.PercentsStackedArea }

AreaChart_StackedArea 

Groups this set of series types: { ChartType.StackedArea }

AreaChart_Area3D 

Groups this set of series types: { ChartType.Area3D }

AreaChart_StackedArea3D 

Groups this set of series types: { ChartType.StackedArea3D }

AreaChart_PercentsStackedArea3D 

Groups this set of series types: { ChartType.PercentsStackedArea3D }

LineChart_Line 

Groups this set of series types: { ChartType.Line, ChartType.LineWithMarkers }

LineChart_StackedLine 

Groups this set of series types: { ChartType.StackedLine, ChartType.StackedLineWithMarkers }

LineChart_PercentsStackedLine 

Groups this set of series types: { ChartType.PercentsStackedLine, ChartType.PercentsStackedLineWithMarkers }

Line3DChart 

Groups this set of series types: { ChartType.Line3D }

StockHighLowClose 

Groups this set of series types: { ChartType.HighLowClose }

StockOpenHighLowClose 

Groups this set of series types: { ChartType.OpenHighLowClose }

StockVolumeHighLowClose 

Groups this set of series types: { ChartType.VolumeHighLowClose }

StockVolumeOpenHighLowClose 

Groups this set of series types: { ChartType.VolumeOpenHighLowClose }

RadarChart 

Groups this set of series types: { ChartType.Radar, ChartType.RadarWithMarkers }

FilledRadarChart 

Groups this set of series types: { ChartType.FilledRadar }

ScatterStraightMarker 

Groups this set of series types: { ChartType.ScatterWithMarkers, ChartType.ScatterWithStraightLines, ChartType.ScatterWithStraightLinesAndMarkers }

ScatterSmoothMarker 

Groups this set of series types: { ChartType.ScatterWithSmoothLines, ChartType.ScatterWithSmoothLinesAndMarkers }

PieChart 

Groups this set of series types: { ChartType.Pie, ChartType.ExplodedPie }

Pie3DChart 

Groups this set of series types: { ChartType.Pie3D, ChartType.ExplodedPie3D }

DoughnutChart 

Groups this set of series types: { ChartType.Doughnut, ChartType.ExplodedDoughnut }

BarChart_VertClustered 

Groups this set of series types: { ChartType.ClusteredColumn }

BarChart_VertStacked 

Groups this set of series types: { ChartType.StackedColumn }

BarChart_VertPercentsStacked 

Groups this set of series types: { ChartType.PercentsStackedColumn }

BarChart_HorizClustered 

Groups this set of series types: { ChartType.ClusteredBar }

BarChart_HorizStacked 

Groups this set of series types: { ChartType.StackedBar }

BarChart_HorizPercentsStacked 

Groups this set of series types: { ChartType.PercentsStackedBar }

Bar3DChart_Vert 

Groups this set of series types: { ChartType.Column3D, ChartType.Cylinder3D, ChartType.Cone3D, ChartType.Pyramid3D }

Bar3DChart_VertClustered 

Groups this set of series types: { ChartType.ClusteredColumn3D, ChartType.ClusteredCone, ChartType.ClusteredCylinder, ChartType.ClusteredPyramid }

Bar3DChart_VertPercentsStackedColumn3D 

Groups this set of series types: { ChartType.PercentsStackedColumn3D }

Bar3DChart_VertPercentsStackedCone 

Groups this set of series types: { ChartType.PercentsStackedCone }

Bar3DChart_VertPercentsStackedCylinder 

Groups this set of series types: { ChartType.PercentsStackedCylinder }

Bar3DChart_VertPercentsStackedPyramid 

Groups this set of series types: { ChartType.PercentsStackedPyramid }

Bar3DChart_VertStackedColumn3D 

Groups this set of series types: { ChartType.StackedColumn3D }

Bar3DChart_VertStackedCone 

Groups this set of series types: { ChartType.StackedCone }

Bar3DChart_VertStackedCylinder 

Groups this set of series types: { ChartType.StackedCylinder }

Bar3DChart_VertStackedPyramid 

Groups this set of series types: { ChartType.StackedPyramid }

Bar3DChart_HorizClustered 

Groups this set of series types: { ChartType.ClusteredBar3D, ChartType.ClusteredHorizontalCone, ChartType.ClusteredHorizontalCylinder, ChartType.ClusteredHorizontalPyramid }

Bar3DChart_HorizStackedBar3D 

Groups this set of series types: { ChartType.StackedBar3D }

Bar3DChart_HorizStackedCone 

Groups this set of series types: { ChartType.StackedHorizontalCone }

Bar3DChart_HorizStackedCylinder 

Groups this set of series types: { ChartType.StackedHorizontalCylinder }

Bar3DChart_HorizStackedPyramid 

Groups this set of series types: { ChartType.StackedHorizontalPyramid }

Bar3DChart_HorizPercentsStackedBar3D 

Groups this set of series types: { ChartType.PercentsStackedBar3D }

Bar3DChart_HorizPercentsStackedCone 

Groups this set of series types: { ChartType.PercentsStackedHorizontalCone }

Bar3DChart_HorizPercentsStackedCylinder 

Groups this set of series types: { ChartType.PercentsStackedHorizontalCylinder }

Bar3DChart_HorizPercentsStackedPyramid 

Groups this set of series types: { ChartType.PercentsStackedHorizontalPyramid }

BarOfPieChart 

Groups this set of series types: { ChartType.BarOfPie }

PieOfPieChart 

Groups this set of series types: { ChartType.PieOfPie }

SurfaceChart_Contour 

Groups this set of series types: { ChartType.Contour }

SurfaceChart_WireframeContour 

Groups this set of series types: { ChartType.WireframeContour }

SurfaceChart_Surface3D 

Groups this set of series types: { ChartType.Surface3D }

SurfaceChart_WireframeSurface3D 

Groups this set of series types: { ChartType.WireframeSurface3D }

BubbleChart 

Groups this set of series types: { ChartType.Bubble, ChartType.BubbleWith3D }

HistogramChart 

Groups this set of series types: { ChartType.Histogram }

ParetoLineChart 

Groups this set of series types: { ChartType.ParetoLine }

BoxAndWhiskerChart 

Groups this set of series types: { ChartType.BoxAndWhisker }

WaterfallChart 

Groups this set of series types: { ChartType.Waterfall }

FunnelChart 

Groups this set of series types: { ChartType.Funnel }

TreemapChart 

Groups this set of series types: { ChartType.Treemap }

SunburstChart 

// Groups this set of series types: // { ChartType.Map } //

//

Groups this set of series types: { ChartType.Sunburst }

◆ CrossesType

Determines where axis will cross.

Enumerator
AxisCrossesAtZero 

The category axis crosses at the zero point of the value axis (if possible), or the minimum value (if the minimum is greater than zero) or the maximum (if the maximum is less than zero).

Maximum 

The axis crosses at the maximum value.

Custom 

Custom value from property CrossAt

◆ DataSourceType

Data source types.

Enumerator
Worksheet 

Use CellXls objects for storing XValue, YValue, Value or BubbleSize of data point in worksheet.

StringLiterals 

Use fast-access string variable for storing XValue, YValue, Value or BubbleSize of data point. Worksheet is NOT used for storing values.

DoubleLiterals 

Use fast-access double variable for storing XValue, YValue, Value or BubbleSize of data point. Worksheet is NOT used for storing values.

◆ DisplayBlanksAsType

Determines how missing data will be displayed.

Enumerator
Gap 

Specifies that blank values shall be left as a gap.

Span 

Specifies that blank values shall be spanned with a line.

Zero 

Specifies that blank values shall be treated as zero.

◆ DisplayUnitType

Determines multiplicity of the displayed data.

Enumerator
None 

Values will dislayed as is.

Hundreds 

Specifies the values on the chart shall be divided by 100.

Thousands 

Specifies the values on the chart shall be divided by 1,000.

TenThousands 

Specifies the values on the chart shall be divided by 10,000.

HundredThousands 

Specifies the values on the chart shall be divided by 100,000.

Millions 

Specifies the values on the chart shall be divided by 1,000,000.

TenMillions 

Specifies the values on the chart shall be divided by 10,000,000.

HundredMillions 

Specifies the values on the chart shall be divided by 100,000,000.

Billions 

Specifies the values on the chart shall be divided by 1,000,000,000.

Trillions 

Specifies the values on the chart shall be divided by 1,000,000,000.

CustomValue 

Specifies the values on the chart shall be divided by a custom value.

◆ ErrorBarType

Represents type of error bar

Enumerator
Both 

Specifies that error bars shall be shown in the positive and negative directions.

Minus 

Specifies that error bars shall be shown in the negative direction only.

Plus 

Specifies that error bars shall be shown in the positive direction only.

◆ ErrorBarValueType

Represents type of error bar value

Enumerator
Custom 

Specifies that the length of the error bars shall be determined by the Plus and Minus elements.

Fixed 

Specifies that the length of the error bars shall be the fixed value determined by Error Bar Value.

Percentage 

Specifies that the length of the error bars shall be Error Bar Value percent of the data.

StandardDeviation 

Specifies that the length of the error bars shall be Error Bar Value standard deviations of the data.

StandardError 

Specifies that the length of the error bars shall be Error Bar Value standard errors of the data.

◆ LegendDataLabelPosition

Determines position of data labels.

Enumerator
NotDefined 

Position is not defined.

Bottom 

Specifies that data labels shall be displayed below the data marker.

BestFit 

Specifies that data labels shall be displayed in the best position.

Center 

Specifies that data labels shall be displayed centered on the data marker.

InsideBase 

Specifies that data labels shall be displayed inside the base of the data marker.

InsideEnd 

Specifies that data labels shall be displayed inside the end of the data marker.

Left 

Specifies that data labels shall be displayed to the left of the data marker.

OutsideEnd 

Specifies that data labels shall be displayed outside the end of the data marker.

Right 

Specifies that data labels shall be displayed to the right of the data marker.

Top 

Specifies that data labels shall be displayed above the data marker.

◆ LegendPositionType

Determines a position of legend on a chart.

Enumerator
Bottom 

Specifies that the legend shall be drawn at the bottom of the chart.

Left 

Specifies that the legend shall be drawn at the left of the chart.

Right 

Specifies that the legend shall be drawn at the right of the chart.

Top 

Specifies that the legend shall be drawn at the top of the chart.

TopRight 

Specifies that the legend shall be drawn at the top right of the chart.

◆ MarkerStyleType

Determines form of marker on chart's data point.

Enumerator
NotDefined 
Circle 

Specifies a circle shall be drawn at each data point.

Dash 

Specifies a dash shall be drawn at each data point.

Diamond 

Specifies a diamond shall be drawn at each data point.

Dot 

Specifies a dot shall be drawn at each data point.

None 

Specifies nothing shall be drawn at each data point.

Picture 

Specifies a picture shall be drawn at each data point.

Plus 

Specifies a plus shall be drawn at each data point.

Square 

Specifies a square shall be drawn at each data point.

Star 

Specifies a star shall be drawn at each data point.

Triangle 

Specifies a triangle shall be drawn at each data point.

Specifies an X shall be drawn at each data point.

◆ ParentLabelLayoutType

Represents layout of category data labels. Used with Treemap series only.

Enumerator
Banner 

Specifies that parent category labels are shown as banner

None 

Specifies that parent category labels are not drawn

Overlapping 

Specifies that parent category labels are shown as overlapping

◆ PictureType

Determines mode of bar picture filling.

Enumerator
NotDefined 

Not defined.

Stack 

The picture is sized to repeat a maximum of 15 times in the longest stacked bar.

StackScale 

The picture is sized to a specified number of units and repeated the length of the bar.

Stretch 

The picture is stretched the full length of the stacked bar.

◆ PieSplitType

Represents a type of splitting points in the second pie or bar on a pie-of-pie or bar-of-pie chart.

Enumerator
Default 

Specifies the data points shall be split using the default mechanism for this chart type.

Custom 

Specifies the data points shall be split between the pie and the second chart according to the Custom Split values.

ByPercentage 

Specifies the data points shall be split between the pie and the second chart by putting the points with percentage less than Split Position percent in the second chart.

ByPos 

Specifies the data points shall be split between the pie and the second chart by putting the last Split Position of the data points in the second chart.

ByValue 

Specifies the data points shall be split between the pie and the second chart by putting the data points with value less than Split Position in the second chart.

◆ QuartileMethodType

Returns type of quartile method

Enumerator
Exclusive 

Represents exclusive quartile method.

Inclusive 

Represents inclusive quartile method.

◆ StyleType

Represents chart style.

Enumerator
Style1 

Style 1

Style2 

Style 2

Style3 

Style 3

Style4 

Style 4

Style5 

Style 5

Style6 

Style 6

Style7 

Style 7

Style8 

Style 8

Style9 

Style 9

Style10 

Style 10

Style11 

Style 11

Style12 

Style 12

Style13 

Style 13

Style14 

Style 14

Style15 

Style 15

Style16 

Style 16

Style17 

Style 17

Style18 

Style 18

Style19 

Style 19

Style20 

Style 20

Style21 

Style 21

Style22 

Style 22

Style23 

Style 23

Style24 

Style 24

Style25 

Style 25

Style26 

Style 26

Style27 

Style 27

Style28 

Style 28

Style29 

Style 29

Style30 

Style 30

Style31 

Style 31

Style32 

Style 32

Style33 

Style 33

Style34 

Style 34

Style35 

Style 35

Style36 

Style 36

Style37 

Style 37

Style38 

Style 38

Style39 

Style 39

Style40 

Style 40

Style41 

Style 41

Style42 

Style 42

Style43 

Style 43

Style44 

Style 44

Style45 

Style 45

Style46 

Style 46

Style47 

Style 47

Style48 

Style 48

◆ TickLabelPositionType

Represents the position type of tick-mark labels on the specified axis.

Enumerator
High 

Specifies the axis labels shall be at the high end of the perpendicular axis.

Low 

Specifies the axis labels shall be at the low end of the perpendicular axis.

NextTo 

Specifies the axis labels shall be next to the axis.

None 

Specifies the axis labels are not drawn.

◆ TickMarkType

Represents the tick mark type for the specified axis.

Enumerator
Cross 

Specifies the tick marks shall cross the axis.

Inside 

Specifies the tick marks shall be inside the plot area.

None 

Specifies there shall be no tick marks.

Outside 

Specifies the tick marks shall be outside the plot area.

◆ TimeUnitType

Represents the base unit for the category axis

Enumerator
Days 

Specifies the chart data shall be shown in days.

Months 

Specifies the chart data shall be shown in months.

Years 

Specifies the chart data shall be shown in years.

◆ TrendlineType

Represents type of trend line

Enumerator
Exponential 

Specifies the trendline shall be an exponential curve in the form.

Linear 

Specifies the trendline shall be a line in the form.

Logarithmic 

Specifies the trendline shall be a logarithmic curve in the form , where log is the natural logarithm.

MovingAverage 

Specifies the trendline shall be a moving average of period Period.

Polynomial 

Specifies the trendline shall be a polynomial curve of order Order in the form.

Power 

Specifies the trendline shall be a power curve in the form.