Aspose::Cells::Charts Namespace Reference

Classes

class  IAxis
 Encapsulates the object that represents a chart's axis. More...
 
class  IChart
 Encapsulates the object that represents a single Excel chart. More...
 
class  IChartArea
 Encapsulates the object that represents the chart area in the worksheet. More...
 
class  IChartCollection
 Encapsulates a collection of Chart objects. More...
 
class  IChartDataTable
 Represents a chart data table. More...
 
class  IChartFrame
 Encapsulates the object that represents the frame object in a chart. More...
 
class  IChartPoint
 Represents a single point in a series in a chart. More...
 
class  IChartPointCollection
 Represents a collection that contains all the points in one series. More...
 
class  IChartTextFrame
 Encapsulates the object that represents the frame object which contains text. More...
 
class  IDataLabels
 Encapsulates a collection of all the DataLabel objects for the specified Series. More...
 
class  IDisplayUnitLabel
 Represents the display unit label. More...
 
class  IDropBars
 Represents the up/down bars in a chart. More...
 
class  IErrorBar
 Represents error bar of data series. More...
 
class  IFloor
 Encapsulates the object that represents the floor of a 3-D chart. More...
 
class  ILegend
 Encapsulates the object that represents the chart legend. More...
 
class  ILegendEntry
 Represents a legend entry in a chart legend. More...
 
class  ILegendEntryCollection
 Represents a collection of all the ILegendEntry objects in the specified chart legend. More...
 
class  IMarker
 Represents the marker in a line chart, scatter chart, or radar chart. More...
 
class  IPivotOptions
 Represents a complex type that specifies the pivot controls that appear on the chart More...
 
class  IPlotArea
 Encapsulates the object that represents the plot area in a chart. More...
 
class  ISeries
 Encapsulates the object that represents a single data series in a chart. More...
 
class  ISeriesCollection
 Encapsulates a collection of Series objects. More...
 
class  ISparkline
 A sparkline represents a tiny chart or graphic in a worksheet cell that provides a visual representation of data. More...
 
class  ISparklineCollection
 Encapsulates a collection of ISparkline objects. More...
 
class  ISparklineGroup
 ISparkline is organized into sparkline group. A SparklineGroup contains a variable number of sparkline items. A sparkline group specifies the type, display settings and axis settings for the sparklines. More...
 
class  ISparklineGroupCollection
 Encapsulates a collection of ISparklineGroup objects. More...
 
class  ITickLabels
 Represents the tick-mark labels associated with tick marks on a chart axis. More...
 
class  ITitle
 Encapsulates the object that represents the title of chart or axis. More...
 
class  ITrendline
 Represents a trendline in a chart. More...
 
class  ITrendlineCollection
 Represents a collection of all the ITrendline objects for the specified data series. More...
 
class  IWalls
 Encapsulates the object that represents the walls of a 3-D chart. More...
 

Enumerations

enum  AxisType { AxisType_Category, AxisType_Value, AxisType_Series }
 Represents the axis type. More...
 
enum  BackgroundMode { BackgroundMode_Automatic, BackgroundMode_Opaque, BackgroundMode_Transparent }
 Represents the display mode of the background. More...
 
enum  Bar3DShapeType {
  Bar3DShapeType_Box, Bar3DShapeType_PyramidToPoint, Bar3DShapeType_PyramidToMax, Bar3DShapeType_Cylinder,
  Bar3DShapeType_ConeToPoint, Bar3DShapeType_ConeToMax
}
 Represents the shape used with the 3-D bar or column chart. More...
 
enum  BubbleSizeRepresents { BubbleSizeRepresents_SizeIsArea, BubbleSizeRepresents_SizeIsWidth }
 Represents what the bubble size represents on a bubble chart. More...
 
enum  CategoryType { CategoryType_AutomaticScale, CategoryType_CategoryScale, CategoryType_TimeScale }
 Represents the category axis type. More...
 
enum  ChartLineFormattingType { ChartLineFormattingType_Automatic, ChartLineFormattingType_Solid, ChartLineFormattingType_None, ChartLineFormattingType_Gradient = 3 }
 Rerepsents line format type of chart line. More...
 
enum  ChartMarkerType {
  ChartMarkerType_Automatic, ChartMarkerType_Circle, ChartMarkerType_Dash, ChartMarkerType_Diamond,
  ChartMarkerType_Dot, ChartMarkerType_None, ChartMarkerType_SquarePlus, ChartMarkerType_Square,
  ChartMarkerType_SquareStar, ChartMarkerType_Triangle, ChartMarkerType_SquareX, ChartMarkerType_Picture
}
 Represents the marker style in a line chart, scatter chart, or radar chart. More...
 
enum  ChartSplitType {
  ChartSplitType_Position, ChartSplitType_Value, ChartSplitType_PercentValue, ChartSplitType_Custom,
  ChartSplitType_Auto
}
 Represents the way the two sections of either a pie of pie chart or a bar of pie chart are split. More...
 
enum  ChartType {
  ChartType_Area, ChartType_AreaStacked, ChartType_Area100PercentStacked, ChartType_Area3D,
  ChartType_Area3DStacked, ChartType_Area3D100PercentStacked, ChartType_Bar, ChartType_BarStacked,
  ChartType_Bar100PercentStacked, ChartType_Bar3DClustered, ChartType_Bar3DStacked, ChartType_Bar3D100PercentStacked,
  ChartType_Bubble, ChartType_Bubble3D, ChartType_Column, ChartType_ColumnStacked,
  ChartType_Column100PercentStacked, ChartType_Column3D, ChartType_Column3DClustered, ChartType_Column3DStacked,
  ChartType_Column3D100PercentStacked, ChartType_Cone, ChartType_ConeStacked, ChartType_Cone100PercentStacked,
  ChartType_ConicalBar, ChartType_ConicalBarStacked, ChartType_ConicalBar100PercentStacked, ChartType_ConicalColumn3D,
  ChartType_Cylinder, ChartType_CylinderStacked, ChartType_Cylinder100PercentStacked, ChartType_CylindricalBar,
  ChartType_CylindricalBarStacked, ChartType_CylindricalBar100PercentStacked, ChartType_CylindricalColumn3D, ChartType_Doughnut,
  ChartType_DoughnutExploded, ChartType_Line, ChartType_LineStacked, ChartType_Line100PercentStacked,
  ChartType_LineWithDataMarkers, ChartType_LineStackedWithDataMarkers, ChartType_Line100PercentStackedWithDataMarkers, ChartType_Line3D,
  ChartType_Pie, ChartType_Pie3D, ChartType_PiePie, ChartType_PieExploded,
  ChartType_Pie3DExploded, ChartType_PieBar, ChartType_Pyramid, ChartType_PyramidStacked,
  ChartType_Pyramid100PercentStacked, ChartType_PyramidBar, ChartType_PyramidBarStacked, ChartType_PyramidBar100PercentStacked,
  ChartType_PyramidColumn3D, ChartType_Radar, ChartType_RadarWithDataMarkers, ChartType_RadarFilled,
  ChartType_Scatter, ChartType_ScatterConnectedByCurvesWithDataMarker, ChartType_ScatterConnectedByCurvesWithoutDataMarker, ChartType_ScatterConnectedByLinesWithDataMarker,
  ChartType_ScatterConnectedByLinesWithoutDataMarker, ChartType_StockHighLowClose, ChartType_StockOpenHighLowClose, ChartType_StockVolumeHighLowClose,
  ChartType_StockVolumeOpenHighLowClose, ChartType_Surface3D, ChartType_SurfaceWireframe3D, ChartType_SurfaceContour,
  ChartType_SurfaceContourWireframe, ChartType_BoxWhisker, ChartType_Funnel, ChartType_ParetoLine,
  ChartType_Sunburst, ChartType_Treemap, ChartType_Waterfall, ChartType_Histogram
}
 Enumerates all chart types used in Excel. More...
 
enum  CrossType { CrossType_Automatic, CrossType_Maximum, CrossType_Custom }
 Represents the axis cross type. More...
 
enum  DataLablesSeparatorType {
  DataLablesSeparatorType_Auto, DataLablesSeparatorType_Space, DataLablesSeparatorType_Comma, DataLablesSeparatorType_Semicolon,
  DataLablesSeparatorType_Period, DataLablesSeparatorType_NewLine, DataLablesSeparatorType_Custom
}
 Represents the separator type of DataLables.
More...
 
enum  DisplayUnitType {
  DisplayUnitType_None = 0x0000, DisplayUnitType_Hundreds = 0x0001, DisplayUnitType_Thousands = 0x0002, DisplayUnitType_TenThousands = 0x0003,
  DisplayUnitType_HundredThousands = 0x0004, DisplayUnitType_Millions = 0x0005, DisplayUnitType_TenMillions = 0x0006, DisplayUnitType_HundredMillions = 0x0007,
  DisplayUnitType_Billions = 0x0008, DisplayUnitType_Trillions = 0x0009, DisplayUnitType_Percentage = 0x000A, DisplayUnitType_Cust
}
 Represents the type of display unit. More...
 
enum  ErrorBarDisplayType { ErrorBarDisplayType_Both, ErrorBarDisplayType_Minus, ErrorBarDisplayType_None, ErrorBarDisplayType_Plus }
 Represents error bar display type. More...
 
enum  ErrorBarType {
  ErrorBarType_Custom, ErrorBarType_FixedValue, ErrorBarType_Percent, ErrorBarType_StDev,
  ErrorBarType_StError
}
 Represents error bar amount type. More...
 
enum  FormattingType { FormattingType_Automatic = 0, FormattingType_Custom = 2, FormattingType_None = 1 }
 Represents the type of formatting applied to an Area object or a Line object. More...
 
enum  LabelPositionType {
  LabelPositionType_Center, LabelPositionType_InsideBase, LabelPositionType_InsideEnd, LabelPositionType_OutsideEnd,
  LabelPositionType_Above, LabelPositionType_Below, LabelPositionType_Left, LabelPositionType_Right,
  LabelPositionType_BestFit, LabelPositionType_Moved
}
 Represents data label position type. More...
 
enum  LegendPositionType {
  LegendPositionType_Bottom = 0, LegendPositionType_Corner = 1, LegendPositionType_Left = 4, LegendPositionType_NotDocked = 7,
  LegendPositionType_Right = 3, LegendPositionType_Top = 2
}
 Enumerates the legend position types. More...
 
enum  PlotEmptyCellsType { PlotEmptyCellsType_NotPlotted, PlotEmptyCellsType_Zero, PlotEmptyCellsType_Interpolated }
 Represents all plot empty cells type of a chart. More...
 
enum  SparklineAxisMinMaxType { SparklineAxisMinMaxType_AutoIndividual, SparklineAxisMinMaxType_Group, SparklineAxisMinMaxType_Custom }
 Represents the minimum and maximum value types for the sparkline vertical axis. More...
 
enum  SparklinePresetStyleType {
  SparklinePresetStyleType_Style1, SparklinePresetStyleType_Style2, SparklinePresetStyleType_Style3, SparklinePresetStyleType_Style4,
  SparklinePresetStyleType_Style5, SparklinePresetStyleType_Style6, SparklinePresetStyleType_Style7, SparklinePresetStyleType_Style8,
  SparklinePresetStyleType_Style9, SparklinePresetStyleType_Style10, SparklinePresetStyleType_Style11, SparklinePresetStyleType_Style12,
  SparklinePresetStyleType_Style13, SparklinePresetStyleType_Style14, SparklinePresetStyleType_Style15, SparklinePresetStyleType_Style16,
  SparklinePresetStyleType_Style17, SparklinePresetStyleType_Style18, SparklinePresetStyleType_Style19, SparklinePresetStyleType_Style20,
  SparklinePresetStyleType_Style21, SparklinePresetStyleType_Style22, SparklinePresetStyleType_Style23, SparklinePresetStyleType_Style24,
  SparklinePresetStyleType_Style25, SparklinePresetStyleType_Style26, SparklinePresetStyleType_Style27, SparklinePresetStyleType_Style28,
  SparklinePresetStyleType_Style29, SparklinePresetStyleType_Style30, SparklinePresetStyleType_Style31, SparklinePresetStyleType_Style32,
  SparklinePresetStyleType_Style33, SparklinePresetStyleType_Style34, SparklinePresetStyleType_Style35, SparklinePresetStyleType_Style36,
  SparklinePresetStyleType_Custom
}
 Represents the preset style types for sparkline. More...
 
enum  SparklineType { SparklineType_Line, SparklineType_Column, SparklineType_Stacked }
 Represents the sparkline types. More...
 
enum  TickLabelPositionType { TickLabelPositionType_High, TickLabelPositionType_Low, TickLabelPositionType_NextToAxis, TickLabelPositionType_None }
 Represents the position type of tick-mark labels on the specified axis. More...
 
enum  TickMarkType { TickMarkType_Cross, TickMarkType_Inside, TickMarkType_None, TickMarkType_Outside }
 Represents the tick mark type for the specified axis. More...
 
enum  TimeUnit { TimeUnit_Days, TimeUnit_Months, TimeUnit_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 the trendline type. More...
 

Enumeration Type Documentation

◆ AxisType

Represents the axis type.

Enumerator
AxisType_Category 

Category axis

AxisType_Value 

Value axis

AxisType_Series 

Series axis

◆ BackgroundMode

Represents the display mode of the background.

Enumerator
BackgroundMode_Automatic 

Automatic

BackgroundMode_Opaque 

Opaque

BackgroundMode_Transparent 

Transparent

◆ Bar3DShapeType

Represents the shape used with the 3-D bar or column chart.

Enumerator
Bar3DShapeType_Box 

Box

Bar3DShapeType_PyramidToPoint 

PyramidToPoint

Bar3DShapeType_PyramidToMax 

PyramidToMax

Bar3DShapeType_Cylinder 

Cylinder

Bar3DShapeType_ConeToPoint 

ConeToPoint

Bar3DShapeType_ConeToMax 

ConeToMax

◆ BubbleSizeRepresents

Represents what the bubble size represents on a bubble chart.

Enumerator
BubbleSizeRepresents_SizeIsArea 

Represents the value of Series.BubbleSizes is area of the bubble.

BubbleSizeRepresents_SizeIsWidth 

Represents the value of Series.BubbleSizes is width of the bubble.

◆ CategoryType

Represents the category axis type.

Enumerator
CategoryType_AutomaticScale 

AutomaticScale

CategoryType_CategoryScale 

CategoryScale

CategoryType_TimeScale 

TimeScale

◆ ChartLineFormattingType

Rerepsents line format type of chart line.

Enumerator
ChartLineFormattingType_Automatic 

Represents automatic formatting type.

ChartLineFormattingType_Solid 

Represents solid formatting type.

ChartLineFormattingType_None 

Represents none formatting type.

ChartLineFormattingType_Gradient 

Gradient

◆ ChartMarkerType

Represents the marker style in a line chart, scatter chart, or radar chart.

Enumerator
ChartMarkerType_Automatic 

Automatic markers.

ChartMarkerType_Circle 

Circular markers.

ChartMarkerType_Dash 

Long bar markers

ChartMarkerType_Diamond 

Diamond-shaped markers.

ChartMarkerType_Dot 

Short bar markers.

ChartMarkerType_None 

No markers.

ChartMarkerType_SquarePlus 

Square markers with a plus sign.

ChartMarkerType_Square 

Square markers.

ChartMarkerType_SquareStar 

Square markers with an asterisk.

ChartMarkerType_Triangle 

Triangular markers.

ChartMarkerType_SquareX 

Square markers with an X.

ChartMarkerType_Picture 

Picture

◆ ChartSplitType

Represents the way the two sections of either a pie of pie chart or a bar of pie chart are split.

Enumerator
ChartSplitType_Position 

Represents 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

ChartSplitType_Value 

Represents 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.

ChartSplitType_PercentValue 

Represents 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.

ChartSplitType_Custom 

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

ChartSplitType_Auto 

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

◆ ChartType

Enumerates all chart types used in Excel.

Enumerator
ChartType_Area 

Represents Area Chart.

ChartType_AreaStacked 

Represents Stacked Area Chart.

ChartType_Area100PercentStacked 

Represents 100% Stacked Area Chart.

ChartType_Area3D 

Represents 3D Area Chart.

ChartType_Area3DStacked 

Represents 3D Stacked Area Chart.

ChartType_Area3D100PercentStacked 

Represents 3D 100% Stacked Area Chart.

ChartType_Bar 

Represents Bar Chart: Clustered Bar Chart.

ChartType_BarStacked 

Represents Stacked Bar Chart.

ChartType_Bar100PercentStacked 

Represents 100% Stacked Bar Chart.

ChartType_Bar3DClustered 

Represents 3D Colustered Bar Chart.

ChartType_Bar3DStacked 

Represents 3D Stacked Bar Chart.

ChartType_Bar3D100PercentStacked 

Represents 3D 100% Stacked Bar Chart.

ChartType_Bubble 

Represents Bubble Chart.

ChartType_Bubble3D 

Represents 3D Bubble Chart.

ChartType_Column 

Represents Column Chart: Clustered Column Chart.

ChartType_ColumnStacked 

Represents Stacked Column Chart.

ChartType_Column100PercentStacked 

Represents 100% Stacked Column Chart.

ChartType_Column3D 

Represents 3D Column Chart.

ChartType_Column3DClustered 

Represents 3D Colustered Column Chart.

ChartType_Column3DStacked 

Represents 3D Stacked Column Chart.

ChartType_Column3D100PercentStacked 

Represents 3D 100% Stacked Column Chart.

ChartType_Cone 

Represents Cone Chart.

ChartType_ConeStacked 

Represents Stacked Cone Chart.

ChartType_Cone100PercentStacked 

Represents 100% Stacked Cone Chart.

ChartType_ConicalBar 

Represents Conical Bar Chart.

ChartType_ConicalBarStacked 

Represents Stacked Conical Bar Chart.

ChartType_ConicalBar100PercentStacked 

Represents 100% Stacked Conical Bar Chart.

ChartType_ConicalColumn3D 

Represents 3D Conical Column Chart.

ChartType_Cylinder 

Represents Cylinder Chart.

ChartType_CylinderStacked 

Represents Stacked Cylinder Chart.

ChartType_Cylinder100PercentStacked 

Represents 100% Stacked Cylinder Chart.

ChartType_CylindricalBar 

Represents Cylindrical Bar Chart.

ChartType_CylindricalBarStacked 

Represents Stacked Cylindrical Bar Chart.

ChartType_CylindricalBar100PercentStacked 

Represents 100% Stacked Cylindrical Bar Chart.

ChartType_CylindricalColumn3D 

Represents 3D Cylindrical Column Chart.

ChartType_Doughnut 

Represents Doughnut Chart.

ChartType_DoughnutExploded 

Represents Exploded Doughnut Chart.

ChartType_Line 

Represents Line Chart.

ChartType_LineStacked 

Represents Stacked Line Chart.

ChartType_Line100PercentStacked 

Represents 100% Stacked Line Chart.

ChartType_LineWithDataMarkers 

Represents Line Chart with data markers.

ChartType_LineStackedWithDataMarkers 

Represents Stacked Line Chart with data markers.

ChartType_Line100PercentStackedWithDataMarkers 

Represents 100% Stacked Line Chart with data markers.

ChartType_Line3D 

Represents 3D Line Chart.

ChartType_Pie 

Represents Pie Chart.

ChartType_Pie3D 

Represents 3D Pie Chart.

ChartType_PiePie 

Represents Pie of Pie Chart.

ChartType_PieExploded 

Represents Exploded Pie Chart.

ChartType_Pie3DExploded 

Represents 3D Exploded Pie Chart.

ChartType_PieBar 

Represents Bar of Pie Chart.

ChartType_Pyramid 

Represents Pyramid Chart.

ChartType_PyramidStacked 

Represents Stacked Pyramid Chart.

ChartType_Pyramid100PercentStacked 

Represents 100% Stacked Pyramid Chart.

ChartType_PyramidBar 

Represents Pyramid Bar Chart.

ChartType_PyramidBarStacked 

Represents Stacked Pyramid Bar Chart.

ChartType_PyramidBar100PercentStacked 

Represents 100% Stacked Pyramid Bar Chart.

ChartType_PyramidColumn3D 

Represents 3D Pyramid Column Chart.

ChartType_Radar 

Represents Radar Chart.

ChartType_RadarWithDataMarkers 

Represents Radar Chart with data markers.

ChartType_RadarFilled 

Represents Filled Radar Chart.

ChartType_Scatter 

Represents Scatter Chart.

ChartType_ScatterConnectedByCurvesWithDataMarker 

Represents Scatter Chart connected by curves, with data markers.

ChartType_ScatterConnectedByCurvesWithoutDataMarker 

Represents Scatter Chart connected by curves, without data markers.

ChartType_ScatterConnectedByLinesWithDataMarker 

Represents Scatter Chart connected by lines, with data markers.

ChartType_ScatterConnectedByLinesWithoutDataMarker 

Represents Scatter Chart connected by lines, without data markers.

ChartType_StockHighLowClose 

Represents High-Low-Close Stock Chart.

ChartType_StockOpenHighLowClose 

Represents Open-High-Low-Close Stock Chart.

ChartType_StockVolumeHighLowClose 

Represents Volume-High-Low-Close Stock Chart.

ChartType_StockVolumeOpenHighLowClose 

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

ChartType_Surface3D 

Represents Surface Chart: 3D Surface Chart.

ChartType_SurfaceWireframe3D 

Represents Wireframe 3D Surface Chart.

ChartType_SurfaceContour 

Represents Contour Chart.

ChartType_SurfaceContourWireframe 

Represents Wireframe Contour Chart.

ChartType_BoxWhisker 

The series is laid out as box and whisker.

ChartType_Funnel 

The series is laid out as a funnel.

ChartType_ParetoLine 

The series is laid out as pareto lines.

ChartType_Sunburst 

The series is laid out as a sunburst.

ChartType_Treemap 

The series is laid out as a treemap.

ChartType_Waterfall 

The series is laid out as a waterfall.

ChartType_Histogram 

The series is laid out as a histogram.

◆ CrossType

Represents the axis cross type.

Enumerator
CrossType_Automatic 

Microsoft Excel sets the axis crossing point.

CrossType_Maximum 

The axis crosses at the maximum value.

CrossType_Custom 

The axis crosses at the custom value.

◆ DataLablesSeparatorType

Represents the separator type of DataLables.

Enumerator
DataLablesSeparatorType_Auto 

Represents automatic separator

DataLablesSeparatorType_Space 

Represents space(" ")

DataLablesSeparatorType_Comma 

Represents comma(",")

DataLablesSeparatorType_Semicolon 

Represents semicolon(";")

DataLablesSeparatorType_Period 

Represents period(".")

DataLablesSeparatorType_NewLine 

Represents newline("\n")

DataLablesSeparatorType_Custom 

Represents custom separator

◆ DisplayUnitType

Represents the type of display unit.

Enumerator
DisplayUnitType_None 

Display unit is None.

DisplayUnitType_Hundreds 

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

DisplayUnitType_Thousands 

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

DisplayUnitType_TenThousands 

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

DisplayUnitType_HundredThousands 

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

DisplayUnitType_Millions 

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

DisplayUnitType_TenMillions 

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

DisplayUnitType_HundredMillions 

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

DisplayUnitType_Billions 

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

DisplayUnitType_Trillions 

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

DisplayUnitType_Percentage 

The values on the chart shall be divided by 0.01.

DisplayUnitType_Cust 

specifies a custom value for the display unit.

◆ ErrorBarDisplayType

Represents error bar display type.

Enumerator
ErrorBarDisplayType_Both 

Both

ErrorBarDisplayType_Minus 

Minus

ErrorBarDisplayType_None 

None

ErrorBarDisplayType_Plus 

Plus

◆ ErrorBarType

Represents error bar amount type.

Enumerator
ErrorBarType_Custom 

InnerCustom value type.

ErrorBarType_FixedValue 

Fixed value type.

ErrorBarType_Percent 

Percentage type

ErrorBarType_StDev 

Standard deviation type.

ErrorBarType_StError 

Standar error type.

◆ FormattingType

Represents the type of formatting applied to an Area object or a Line object.

Enumerator
FormattingType_Automatic 

Represents automatic formatting type.

FormattingType_Custom 

Represents custom formatting type.

FormattingType_None 

Represents none formatting type.

◆ LabelPositionType

Represents data label position type.

Enumerator
LabelPositionType_Center 

Applies only to bar, 2d/3d pie charts

LabelPositionType_InsideBase 

Applies only to bar, 2d/3d pie charts

LabelPositionType_InsideEnd 

Applies only to bar charts

LabelPositionType_OutsideEnd 

Applies only to bar, 2d/3d pie charts

LabelPositionType_Above 

Applies only to line charts

LabelPositionType_Below 

Applies only to line charts

LabelPositionType_Left 

Applies only to line charts

LabelPositionType_Right 

Applies only to line charts

LabelPositionType_BestFit 

Applies only to 2d/3d pie charts

LabelPositionType_Moved 

User moved the data labels, Only for reading chart from template file.

◆ LegendPositionType

Enumerates the legend position types.

Enumerator
LegendPositionType_Bottom 

Displays the legend to the bottom of the chart's plot area.

LegendPositionType_Corner 

Displays the legend to the corner of the chart's plot area.

LegendPositionType_Left 

Displays the legend to the left of the chart's plot area.

LegendPositionType_NotDocked 

Represents that the legend is not docked.

LegendPositionType_Right 

Displays the legend to the right of the chart's plot area.

LegendPositionType_Top 

Displays the legend to the top of the chart's plot area.

◆ PlotEmptyCellsType

Represents all plot empty cells type of a chart.

Enumerator
PlotEmptyCellsType_NotPlotted 

Not plotted(leave gap)

PlotEmptyCellsType_Zero 

Zero

PlotEmptyCellsType_Interpolated 

Interpolated

◆ SparklineAxisMinMaxType

Represents the minimum and maximum value types for the sparkline vertical axis.

Enumerator
SparklineAxisMinMaxType_AutoIndividual 

Automatic for each sparkline.

SparklineAxisMinMaxType_Group 

Same for all sparklines in the group.

SparklineAxisMinMaxType_Custom 

InnerCustom value for sparkline.

◆ SparklinePresetStyleType

Represents the preset style types for sparkline.

Enumerator
SparklinePresetStyleType_Style1 

Style 1

SparklinePresetStyleType_Style2 

Style 2

SparklinePresetStyleType_Style3 

Style 3

SparklinePresetStyleType_Style4 

Style 4

SparklinePresetStyleType_Style5 

Style 5

SparklinePresetStyleType_Style6 

Style 6

SparklinePresetStyleType_Style7 

Style 7

SparklinePresetStyleType_Style8 

Style 8

SparklinePresetStyleType_Style9 

Style 9

SparklinePresetStyleType_Style10 

Style 10

SparklinePresetStyleType_Style11 

Style 11

SparklinePresetStyleType_Style12 

Style 12

SparklinePresetStyleType_Style13 

Style 13

SparklinePresetStyleType_Style14 

Style 14

SparklinePresetStyleType_Style15 

Style 15

SparklinePresetStyleType_Style16 

Style 16

SparklinePresetStyleType_Style17 

Style 17

SparklinePresetStyleType_Style18 

Style 18

SparklinePresetStyleType_Style19 

Style 19

SparklinePresetStyleType_Style20 

Style 20

SparklinePresetStyleType_Style21 

Style 21

SparklinePresetStyleType_Style22 

Style 22

SparklinePresetStyleType_Style23 

Style 23

SparklinePresetStyleType_Style24 

Style 24

SparklinePresetStyleType_Style25 

Style 25

SparklinePresetStyleType_Style26 

Style 26

SparklinePresetStyleType_Style27 

Style 27

SparklinePresetStyleType_Style28 

Style 28

SparklinePresetStyleType_Style29 

Style 29

SparklinePresetStyleType_Style30 

Style 30

SparklinePresetStyleType_Style31 

Style 31

SparklinePresetStyleType_Style32 

Style 32

SparklinePresetStyleType_Style33 

Style 33

SparklinePresetStyleType_Style34 

Style 34

SparklinePresetStyleType_Style35 

Style 35

SparklinePresetStyleType_Style36 

Style 36

SparklinePresetStyleType_Custom 

No preset style.

◆ SparklineType

Represents the sparkline types.

Enumerator
SparklineType_Line 

Line sparkline.

SparklineType_Column 

Column sparkline.

SparklineType_Stacked 

Win/Loss sparkline.

◆ TickLabelPositionType

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

Enumerator
TickLabelPositionType_High 

Position type is high.

TickLabelPositionType_Low 

Position type is low.

TickLabelPositionType_NextToAxis 

Position type is next to axis.

TickLabelPositionType_None 

Position type is none.

◆ TickMarkType

Represents the tick mark type for the specified axis.

Enumerator
TickMarkType_Cross 

Tick mark type is Cross.

TickMarkType_Inside 

Tick mark type is Inside.

TickMarkType_None 

Tick mark type is None.

TickMarkType_Outside 

Tick mark type is Outside

◆ TimeUnit

Represents the base unit for the category axis.

Enumerator
TimeUnit_Days 

Days

TimeUnit_Months 

Months

TimeUnit_Years 

Years

◆ TrendlineType

Represents the trendline type.

Enumerator
TrendlineType_Exponential 

Exponential

TrendlineType_Linear 

Linear

TrendlineType_Logarithmic 

Logarithmic

TrendlineType_MovingAverage 

MovingAverage

TrendlineType_Polynomial 

Polynomial

TrendlineType_Power 

Power