Enumerations
This topic provides a list of all enumerations in the Graph object model.
XlArabicModes
Name |
Value |
|---|---|
xlArabicBothStrict |
3 |
xlArabicNone |
0 |
xlArabicStrictAlefHamza |
1 |
xlArabicStrictFinalYaa |
2 |
XlArrowHeadLength
Name |
Value |
|---|---|
xlArrowHeadLengthLong |
3 |
xlArrowHeadLengthMedium |
-4138 |
xlArrowHeadLengthShort |
1 |
XlArrowHeadStyle
Name |
Value |
|---|---|
xlArrowHeadStyleClosed |
3 |
xlArrowHeadStyleDoubleClosed |
5 |
xlArrowHeadStyleDoubleOpen |
4 |
xlArrowHeadStyleNone |
-4142 |
xlArrowHeadStyleOpen |
2 |
XlArrowHeadWidth
Name |
Value |
|---|---|
xlArrowHeadWidthMedium |
-4138 |
xlArrowHeadWidthNarrow |
1 |
xlArrowHeadWidthWide |
3 |
XlAxisCrosses
Name |
Value |
|---|---|
xlAxisCrossesAutomatic |
-4105 |
xlAxisCrossesCustom |
-4114 |
xlAxisCrossesMaximum |
2 |
xlAxisCrossesMinimum |
4 |
XlAxisGroup
Name |
Value |
|---|---|
xlPrimary |
1 |
xlSecondary |
2 |
XlAxisType
Name |
Value |
|---|---|
xlCategory |
1 |
xlSeriesAxis |
3 |
xlValue |
2 |
XlBackground
Name |
Value |
|---|---|
xlBackgroundAutomatic |
-4105 |
xlBackgroundOpaque |
3 |
xlBackgroundTransparent |
2 |
XlBarShape
Name |
Value |
|---|---|
xlBox |
0 |
xlConeToMax |
5 |
xlConeToPoint |
4 |
xlCylinder |
3 |
xlPyramidToMax |
2 |
xlPyramidToPoint |
1 |
XlBorderWeight
Name |
Value |
|---|---|
xlHairline |
1 |
xlMedium |
-4138 |
xlThick |
4 |
xlThin |
2 |
XlCalculatedMemberType
Name |
Value |
|---|---|
xlCalculatedMember |
0 |
xlCalculatedSet |
1 |
XlCategoryType
Name |
Value |
|---|---|
xlAutomaticScale |
-4105 |
xlCategoryScale |
2 |
xlTimeScale |
3 |
XlChartGallery
Name |
Value |
|---|---|
xlAnyGallery |
23 |
xlBuiltIn |
21 |
xlUserDefined |
22 |
XlChartItem
Name |
Value |
|---|---|
xlAxis |
21 |
xlAxisTitle |
17 |
xlChartArea |
2 |
xlChartTitle |
4 |
xlCorners |
6 |
xlDataLabel |
0 |
xlDataTable |
7 |
xlDisplayUnitLabel |
30 |
xlDownBars |
20 |
xlDropLines |
26 |
xlErrorBars |
9 |
xlFloor |
23 |
xlHiLoLines |
25 |
xlLeaderLines |
29 |
xlLegend |
24 |
xlLegendEntry |
12 |
xlLegendKey |
13 |
xlMajorGridlines |
15 |
xlMinorGridlines |
16 |
xlNothing |
28 |
xlPivotChartDropZone |
32 |
xlPivotChartFieldButton |
31 |
xlPlotArea |
19 |
xlRadarAxisLabels |
27 |
xlSeries |
3 |
xlSeriesLines |
22 |
xlShape |
14 |
xlTrendline |
8 |
xlUpBars |
18 |
xlWalls |
5 |
xlXErrorBars |
10 |
xlYErrorBars |
11 |
XlChartPicturePlacement
Name |
Value |
|---|---|
xlAllFaces |
7 |
xlEnd |
2 |
xlEndSides |
3 |
xlFront |
4 |
xlFrontEnd |
6 |
xlFrontSides |
5 |
xlSides |
1 |
XlChartPictureType
Name |
Value |
|---|---|
xlStack |
2 |
xlStackScale |
3 |
xlStretch |
1 |
XlChartSplitType
Name |
Value |
|---|---|
xlSplitByCustomSplit |
4 |
xlSplitByPercentValue |
3 |
xlSplitByPosition |
1 |
xlSplitByValue |
2 |
XlChartType
Name |
Value |
|---|---|
xl3DArea |
-4098 |
xl3DAreaStacked |
78 |
xl3DAreaStacked100 |
79 |
xl3DBarClustered |
60 |
xl3DBarStacked |
61 |
xl3DBarStacked100 |
62 |
xl3DColumn |
-4100 |
xl3DColumnClustered |
54 |
xl3DColumnStacked |
55 |
xl3DColumnStacked100 |
56 |
xl3DLine |
-4101 |
xl3DPie |
-4102 |
xl3DPieExploded |
70 |
xlArea |
1 |
xlAreaStacked |
76 |
xlAreaStacked100 |
77 |
xlBarClustered |
57 |
xlBarOfPie |
71 |
xlBarStacked |
58 |
xlBarStacked100 |
59 |
xlBubble |
15 |
xlBubble3DEffect |
87 |
xlColumnClustered |
51 |
xlColumnStacked |
52 |
xlColumnStacked100 |
53 |
xlConeBarClustered |
102 |
xlConeBarStacked |
103 |
xlConeBarStacked100 |
104 |
xlConeCol |
105 |
xlConeColClustered |
99 |
xlConeColStacked |
100 |
xlConeColStacked100 |
101 |
xlCylinderBarClustered |
95 |
xlCylinderBarStacked |
96 |
xlCylinderBarStacked100 |
97 |
xlCylinderCol |
98 |
xlCylinderColClustered |
92 |
xlCylinderColStacked |
93 |
xlCylinderColStacked100 |
94 |
xlDoughnut |
-4120 |
xlDoughnutExploded |
80 |
xlLine |
4 |
xlLineMarkers |
65 |
xlLineMarkersStacked |
66 |
xlLineMarkersStacked100 |
67 |
xlLineStacked |
63 |
xlLineStacked100 |
64 |
xlPie |
5 |
xlPieExploded |
69 |
xlPieOfPie |
68 |
xlPyramidBarClustered |
109 |
xlPyramidBarStacked |
110 |
xlPyramidBarStacked100 |
111 |
xlPyramidCol |
112 |
xlPyramidColClustered |
106 |
xlPyramidColStacked |
107 |
xlPyramidColStacked100 |
108 |
xlRadar |
-4151 |
xlRadarFilled |
82 |
xlRadarMarkers |
81 |
xlStockHLC |
88 |
xlStockOHLC |
89 |
xlStockVHLC |
90 |
xlStockVOHLC |
91 |
xlSurface |
83 |
xlSurfaceTopView |
85 |
xlSurfaceTopViewWireframe |
86 |
xlSurfaceWireframe |
84 |
xlXYScatter |
-4169 |
xlXYScatterLines |
74 |
xlXYScatterLinesNoMarkers |
75 |
xlXYScatterSmooth |
72 |
xlXYScatterSmoothNoMarkers |
73 |
XlCmdType
Name |
Value |
|---|---|
xlCmdCube |
1 |
xlCmdDefault |
4 |
xlCmdList |
5 |
xlCmdSql |
2 |
xlCmdTable |
3 |
XlColorIndex
Name |
Value |
|---|---|
xlColorIndexAutomatic |
-4105 |
xlColorIndexNone |
-4142 |
XlColumnDataType
Name |
Value |
|---|---|
xlDMYFormat |
4 |
xlDYMFormat |
7 |
xlEMDFormat |
10 |
xlGeneralFormat |
1 |
xlMDYFormat |
3 |
xlMYDFormat |
6 |
xlSkipColumn |
9 |
xlTextFormat |
2 |
xlYDMFormat |
8 |
xlYMDFormat |
5 |
XlConsolidationFunction
Name |
Value |
|---|---|
xlAverage |
-4106 |
xlCount |
-4112 |
xlCountNums |
-4113 |
xlMax |
-4136 |
xlMin |
-4139 |
xlProduct |
-4149 |
xlStDev |
-4155 |
xlStDevP |
-4156 |
xlSum |
-4157 |
xlUnknown |
1000 |
xlVar |
-4164 |
xlVarP |
-4165 |
XlCopyPictureFormat
Name |
Value |
|---|---|
xlBitmap |
2 |
xlPicture |
-4147 |
XlCreator
Name |
Value |
|---|---|
xlCreatorCode |
1480803660 |
XlCubeFieldType
Name |
Value |
|---|---|
xlHierarchy |
1 |
xlMeasure |
2 |
xlSet |
3 |
XlDataLabelPosition
Name |
Value |
|---|---|
xlLabelPositionAbove |
0 |
xlLabelPositionBelow |
1 |
xlLabelPositionBestFit |
5 |
xlLabelPositionCenter |
-4108 |
xlLabelPositionCustom |
7 |
xlLabelPositionInsideBase |
4 |
xlLabelPositionInsideEnd |
3 |
xlLabelPositionLeft |
-4131 |
xlLabelPositionMixed |
6 |
xlLabelPositionOutsideEnd |
2 |
xlLabelPositionRight |
-4152 |
XlDataLabelSeparator
Name |
Value |
|---|---|
xlDataLabelSeparatorDefault |
1 |
XlDataLabelsType
Name |
Value |
|---|---|
xlDataLabelsShowBubbleSizes |
6 |
xlDataLabelsShowLabel |
4 |
xlDataLabelsShowLabelAndPercent |
5 |
xlDataLabelsShowNone |
-4142 |
xlDataLabelsShowPercent |
3 |
xlDataLabelsShowValue |
2 |
XlDataSeriesDate
Name |
Value |
|---|---|
xlDay |
1 |
xlMonth |
3 |
xlWeekday |
2 |
xlYear |
4 |
XlDataSeriesType
Name |
Value |
|---|---|
xlAutoFill |
4 |
xlChronological |
3 |
xlDataSeriesLinear |
-4132 |
xlGrowth |
2 |
XlDeleteShiftDirection
Name |
Value |
|---|---|
xlShiftToLeft |
-4159 |
xlShiftUp |
-4162 |
XlDirection
Name |
Value |
|---|---|
xlDown |
-4121 |
xlToLeft |
-4159 |
xlToRight |
-4161 |
xlUp |
-4162 |
XlDisplayBlanksAs
Name |
Value |
|---|---|
xlInterpolated |
3 |
xlNotPlotted |
1 |
xlZero |
2 |
XlDisplayDrawingObjects
Name |
Value |
|---|---|
xlDisplayShapes |
-4104 |
xlHide |
3 |
xlPlaceholders |
2 |
XlDisplayUnit
Name |
Value |
|---|---|
xlHundredMillions |
-8 |
xlHundreds |
-2 |
xlHundredThousands |
-5 |
xlMillionMillions |
-10 |
xlMillions |
-6 |
xlTenMillions |
-7 |
xlTenThousands |
-4 |
xlThousandMillions |
-9 |
xlThousands |
-3 |
XlEndStyleCap
Name |
Value |
|---|---|
xlCap |
1 |
xlNoCap |
2 |
XlErrorBarDirection
Name |
Value |
|---|---|
xlX |
-4168 |
xlY |
1 |
XlErrorBarInclude
Name |
Value |
|---|---|
xlErrorBarIncludeBoth |
1 |
xlErrorBarIncludeMinusValues |
3 |
xlErrorBarIncludeNone |
-4142 |
xlErrorBarIncludePlusValues |
2 |
XlErrorBarType
Name |
Value |
|---|---|
xlErrorBarTypeCustom |
-4114 |
xlErrorBarTypeFixedValue |
1 |
xlErrorBarTypePercent |
2 |
xlErrorBarTypeStDev |
-4155 |
xlErrorBarTypeStError |
4 |
XlFindLookIn
Name |
Value |
|---|---|
xlComments |
-4144 |
xlFormulas |
-4123 |
xlValues |
-4163 |
XlHAlign
Name |
Value |
|---|---|
xlHAlignCenter |
-4108 |
xlHAlignCenterAcrossSelection |
7 |
xlHAlignDistributed |
-4117 |
xlHAlignFill |
5 |
xlHAlignGeneral |
1 |
xlHAlignJustify |
-4130 |
xlHAlignLeft |
-4131 |
xlHAlignRight |
-4152 |
XlHebrewModes
Name |
Value |
|---|---|
xlHebrewFullScript |
0 |
xlHebrewMixedAuthorizedScript |
3 |
xlHebrewMixedScript |
2 |
xlHebrewPartialScript |
1 |
XlImportDataAs
Name |
Value |
|---|---|
xlPivotTableReport |
1 |
xlQueryTable |
0 |
XlInsertFormatOrigin
Name |
Value |
|---|---|
xlFormatFromLeftOrAbove |
0 |
xlFormatFromRightOrBelow |
1 |
XlInsertShiftDirection
Name |
Value |
|---|---|
xlShiftDown |
-4121 |
xlShiftToRight |
-4161 |
XlLegendPosition
Name |
Value |
|---|---|
xlLegendPositionBottom |
-4107 |
xlLegendPositionCorner |
2 |
xlLegendPositionLeft |
-4131 |
xlLegendPositionRight |
-4152 |
xlLegendPositionTop |
-4160 |
XlLineStyle
Name |
Value |
|---|---|
xlContinuous |
1 |
xlDash |
-4115 |
xlDashDot |
4 |
xlDashDotDot |
5 |
xlDot |
-4118 |
xlDouble |
-4119 |
xlLineStyleNone |
-4142 |
xlSlantDashDot |
13 |
XlLocationInTable
Name |
Value |
|---|---|
xlColumnHeader |
-4110 |
xlColumnItem |
5 |
xlDataHeader |
3 |
xlDataItem |
7 |
xlPageHeader |
2 |
xlPageItem |
6 |
xlRowHeader |
-4153 |
xlRowItem |
4 |
xlTableBody |
8 |
XlMarkerStyle
Name |
Value |
|---|---|
xlMarkerStyleAutomatic |
-4105 |
xlMarkerStyleCircle |
8 |
xlMarkerStyleDash |
-4115 |
xlMarkerStyleDiamond |
2 |
xlMarkerStyleDot |
-4118 |
xlMarkerStyleNone |
-4142 |
xlMarkerStylePicture |
-4147 |
xlMarkerStylePlus |
9 |
xlMarkerStyleSquare |
1 |
xlMarkerStyleStar |
5 |
xlMarkerStyleTriangle |
3 |
xlMarkerStyleX |
-4168 |
XlOrientation
Name |
Value |
|---|---|
xlDownward |
-4170 |
xlHorizontal |
-4128 |
xlUpward |
-4171 |
xlVertical |
-4166 |
XlPattern
Name |
Value |
|---|---|
xlPatternAutomatic |
-4105 |
xlPatternChecker |
9 |
xlPatternCrissCross |
16 |
xlPatternDown |
-4121 |
xlPatternGray16 |
17 |
xlPatternGray25 |
-4124 |
xlPatternGray50 |
-4125 |
xlPatternGray75 |
-4126 |
xlPatternGray8 |
18 |
xlPatternGrid |
15 |
xlPatternHorizontal |
-4128 |
xlPatternLightDown |
13 |
xlPatternLightHorizontal |
11 |
xlPatternLightUp |
14 |
xlPatternLightVertical |
12 |
xlPatternNone |
-4142 |
xlPatternSemiGray75 |
10 |
xlPatternSolid |
1 |
xlPatternUp |
-4162 |
xlPatternVertical |
-4166 |
XlPictureConvertorType
Name |
Value |
|---|---|
xlBMP |
1 |
xlCGM |
7 |
xlDRW |
4 |
xlDXF |
5 |
xlEPS |
8 |
xlHGL |
6 |
xlPCT |
13 |
xlPCX |
10 |
xlPIC |
11 |
xlPLT |
12 |
xlTIF |
9 |
xlWMF |
2 |
xlWPG |
3 |
XlPivotFieldDataType
Name |
Value |
|---|---|
xlDate |
2 |
xlNumber |
-4145 |
xlText |
-4158 |
XlPivotFormatType
Name |
Value |
|---|---|
xlPTClassic |
20 |
xlPTNone |
21 |
xlReport1 |
0 |
xlReport10 |
9 |
xlReport2 |
1 |
xlReport3 |
2 |
xlReport4 |
3 |
xlReport5 |
4 |
xlReport6 |
5 |
xlReport7 |
6 |
xlReport8 |
7 |
xlReport9 |
8 |
xlTable1 |
10 |
xlTable10 |
19 |
xlTable2 |
11 |
xlTable3 |
12 |
xlTable4 |
13 |
xlTable5 |
14 |
xlTable6 |
15 |
xlTable7 |
16 |
xlTable8 |
17 |
xlTable9 |
18 |
XlPivotTableSourceType
Name |
Value |
|---|---|
xlConsolidation |
3 |
xlDatabase |
1 |
xlExternal |
2 |
xlPivotTable |
-4148 |
xlScenario |
4 |
XlQueryType
Name |
Value |
|---|---|
xlADORecordset |
7 |
xlDAORecordset |
2 |
xlODBCQuery |
1 |
xlOLEDBQuery |
5 |
xlTextImport |
6 |
xlWebQuery |
4 |
XlRangeValueDataType
Name |
Value |
|---|---|
xlRangeValueDefault |
10 |
xlRangeValueMSPersistXML |
12 |
xlRangeValueXMLSpreadsheet |
11 |
XlReferenceStyle
Name |
Value |
|---|---|
xlA1 |
1 |
xlR1C1 |
-4150 |
XlRowCol
Name |
Value |
|---|---|
xlColumns |
2 |
xlRows |
1 |
XlScaleType
Name |
Value |
|---|---|
xlScaleLinear |
-4132 |
xlScaleLogarithmic |
-4133 |
XlSheetType
Name |
Value |
|---|---|
xlChart |
-4109 |
xlDialogSheet |
-4116 |
xlExcel4IntlMacroSheet |
4 |
xlExcel4MacroSheet |
3 |
xlWorksheet |
-4167 |
XlSizeRepresents
Name |
Value |
|---|---|
xlSizeIsArea |
1 |
xlSizeIsWidth |
2 |
XlSubtototalLocationType
Name |
Value |
|---|---|
xlAtBottom |
2 |
xlAtTop |
1 |
XlTickLabelOrientation
Name |
Value |
|---|---|
xlTickLabelOrientationAutomatic |
-4105 |
xlTickLabelOrientationDownward |
-4170 |
xlTickLabelOrientationHorizontal |
-4128 |
xlTickLabelOrientationUpward |
-4171 |
xlTickLabelOrientationVertical |
-4166 |
XlTickLabelPosition
Name |
Value |
|---|---|
xlTickLabelPositionHigh |
-4127 |
xlTickLabelPositionLow |
-4134 |
xlTickLabelPositionNextToAxis |
4 |
xlTickLabelPositionNone |
-4142 |
XlTickMark
Name |
Value |
|---|---|
xlTickMarkCross |
4 |
xlTickMarkInside |
2 |
xlTickMarkNone |
-4142 |
xlTickMarkOutside |
3 |
XlTimeUnit
Name |
Value |
|---|---|
xlDays |
0 |
xlMonths |
1 |
xlYears |
2 |
XlTrendlineType
Name |
Value |
|---|---|
xlExponential |
5 |
xlLinear |
-4132 |
xlLogarithmic |
-4133 |
xlMovingAvg |
6 |
xlPolynomial |
3 |
xlPower |
4 |
XlUnderlineStyle
Name |
Value |
|---|---|
xlUnderlineStyleDouble |
-4119 |
xlUnderlineStyleDoubleAccounting |
5 |
xlUnderlineStyleNone |
-4142 |
xlUnderlineStyleSingle |
2 |
xlUnderlineStyleSingleAccounting |
4 |
XlVAlign
Name |
Value |
|---|---|
xlVAlignBottom |
-4107 |
xlVAlignCenter |
-4108 |
xlVAlignDistributed |
-4117 |
xlVAlignJustify |
-4130 |
xlVAlignTop |
-4160 |
XlWebFormatting
Name |
Value |
|---|---|
xlWebFormattingAll |
1 |
xlWebFormattingNone |
3 |
xlWebFormattingRTF |
2 |
XlWebSelectionType
Name |
Value |
|---|---|
xlAllTables |
2 |
xlEntirePage |
1 |
xlSpecifiedTables |
3 |
XlWindowState
Name |
Value |
|---|---|
xlMaximized |
-4137 |
xlMinimized |
-4140 |
xlNormal |
-4143 |
XlWindowType
Name |
Value |
|---|---|
xlChartAsWindow |
5 |
xlChartInPlace |
4 |
xlClipboard |
3 |
xlInfo |
-4129 |
xlWorkbook |
1 |