Enumerações (referência do Graph Visual Basic)

Este tópico fornece uma lista de todas as enumerações no modelo de objeto do Graph.

Para obter descrições mais detalhadas, confira o seguinte:

• Enumerações (Excel)
• Enumerações (Office)

XlArabicModes

Nome	Valor
xlArabicBothStrict	3
xlArabicNone	0
xlArabicStrictAlefHamza	1
xlArabicStrictFinalYaa	2

XlArrowHeadLength

Nome	Valor
xlArrowHeadLengthLong	3
xlArrowHeadLengthMedium	-4138
xlArrowHeadLengthShort	1

XlArrowHeadStyle

Nome	Valor
xlArrowHeadStyleClosed	3
xlArrowHeadStyleDoubleClosed	5
xlArrowHeadStyleDoubleOpen	4
xlArrowHeadStyleNone	-4142
xlArrowHeadStyleOpen	2

XlArrowHeadWidth

Nome	Valor
xlArrowHeadWidthMedium	-4138
xlArrowHeadWidthNarrow	1
xlArrowHeadWidthWide	3

XlAxisCrosses

Nome	Valor
xlAxisCrossesAutomatic	-4105
xlAxisCrossesCustom	-4114
xlAxisCrossesMaximum	2
xlAxisCrossesMinimum	4

XlAxisGroup

Nome	Valor
xlPrimary	1
xlSecondary	2

XlAxisType

Nome	Valor
Xlcategory	1
Xlseriesaxis	3
Xlvalue	2

XlBackground

Nome	Valor
xlBackgroundAutomatic	-4105
xlBackgroundOpaque	3
xlBackgroundTransparent	2

XlBarShape

Nome	Valor
xlBox	0
xlConeToMax	5
xlConeToPoint	4
xlCylinder	3
xlPyramidToMax	2
xlPyramidToPoint	1

XlBorderWeight

Nome	Valor
xlHairline	1
xlMedium	-4138
xlThick	4
xlThin	2

XlCalculatedMemberType

Nome	Valor
xlCalculatedMember	0
xlCalculatedSet	1

XlCategoryType

Nome	Valor
xlAutomaticScale	-4105
xlCategoryScale	2
xlTimeScale	3

XlChartGallery

Nome	Valor
xlAnyGallery	23
xlBuiltIn	21
xlUserDefined	22

XlChartItem

Nome	Valor
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

Nome	Valor
xlAllFaces	7
xlEnd	2
xlEndSides	3
xlFront	4
xlFrontEnd	6
xlFrontSides	5
xlSides	1

XlChartPictureType

Nome	Valor
xlStack	2
xlStackScale	3
xlStretch	1

XlChartSplitType

Nome	Valor
xlSplitByCustomSplit	4
xlSplitByPercentValue	3
xlSplitByPosition	1
xlSplitByValue	2

XlChartType

Nome	Valor
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

Nome	Valor
xlCmdCube	1
xlCmdDefault	4
xlCmdList	5
xlCmdSql	2
xlCmdTable	3

XlColorIndex

Nome	Valor
xlColorIndexAutomatic	-4105
xlColorIndexNone	-4142

XlColumnDataType

Nome	Valor
xlDMYFormat	4
xlDYMFormat	7
xlEMDFormat	10
xlGeneralFormat	1
xlMDYFormat	3
xlMYDFormat	6
xlSkipColumn	9
xlTextFormat	2
xlYDMFormat	8
xlYMDFormat	5

XlConsolidationFunction

Nome	Valor
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

Nome	Valor
xlBitmap	2
xlPicture	-4147

XlCreator

Nome	Valor
xlCreatorCode	1480803660

XlCubeFieldType

Nome	Valor
xlHierarchy	1
xlMeasure	2
xlSet	3

XlDataLabelPosition

Nome	Valor
xlLabelPositionAbove	0
xlLabelPositionBelow	1
xlLabelPositionBestFit	5
xlLabelPositionCenter	-4108
xlLabelPositionCustom	7
xlLabelPositionInsideBase	4
xlLabelPositionInsideEnd	3
xlLabelPositionLeft	-4131
xlLabelPositionMixed	6
xlLabelPositionOutsideEnd	2
xlLabelPositionRight	-4152

XlDataLabelSeparator

Nome	Valor
xlDataLabelSeparatorDefault	1

XlDataLabelsType

Nome	Valor
xlDataLabelsShowBubbleSizes	6
xlDataLabelsShowLabel	4
xlDataLabelsShowLabelAndPercent	5
xlDataLabelsShowNone	-4142
xlDataLabelsShowPercent	3
xlDataLabelsShowValue	2

XlDataSeriesDate

Nome	Valor
xlDay	1
xlMonth	3
xlWeekday	2
xlYear	4

XlDataSeriesType

Nome	Valor
xlAutoFill	4
xlChronological	3
xlDataSeriesLinear	-4132
xlGrowth	2

XlDeleteShiftDirection

Nome	Valor
xlShiftToLeft	-4159
xlShiftUp	-4162

XlDirection

Nome	Valor
xlDown	-4121
xlToLeft	-4159
xlToRight	-4161
xlUp	-4162

XlDisplayBlanksAs

Nome	Valor
Xlinterpolated	3
Xlnotplotted	1
Xlzero	2

XlDisplayDrawingObjects

Nome	Valor
xlDisplayShapes	-4104
xlHide	3
xlPlaceholders	2

XlDisplayUnit

Nome	Valor
xlHundredMillions	-8
xlHundreds	-2
xlHundredThousands	-5
xlMillionMillions	-10
xlMillions	-6
xlTenMillions	-7
xlTenThousands	-4
xlThousandMillions	-9
xlThousands	-3

XlEndStyleCap

Nome	Valor
xlCap	1
xlNoCap	2

XlErrorBarDirection

Nome	Valor
Xlx	-4168
xlY	1

XlErrorBarInclude

Nome	Valor
xlErrorBarIncludeBoth	1
xlErrorBarIncludeMinusValues	3
xlErrorBarIncludeNone	-4142
xlErrorBarIncludePlusValues	2

XlErrorBarType

Nome	Valor
xlErrorBarTypeCustom	-4114
xlErrorBarTypeFixedValue	1
xlErrorBarTypePercent	2
xlErrorBarTypeStDev	-4155
xlErrorBarTypeStError	4

XlFindLookIn

Nome	Valor
xlComments	-4144
xlFormulas	-4123
xlValues	-4163

XlHAlign

Nome	Valor
xlHAlignCenter	-4108
xlHAlignCenterAcrossSelection	7
xlHAlignDistributed	-4117
xlHAlignFill	5
xlHAlignGeneral	1
xlHAlignJustify	-4130
xlHAlignLeft	-4131
xlHAlignRight	-4152

XlHebrewModes

Nome	Valor
xlHebrewFullScript	0
xlHebrewMixedAuthorizedScript	3
xlHebrewMixedScript	2
xlHebrewPartialScript	1

XlImportDataAs

Nome	Valor
xlPivotTableReport	1
xlQueryTable	0

XlInsertFormatOrigin

Nome	Valor
xlFormatFromLeftOrAbove	0
xlFormatFromRightOrBelow	1

XlInsertShiftDirection

Nome	Valor
xlShiftDown	-4121
xlShiftToRight	-4161

XlLegendPosition

Nome	Valor
xlLegendPositionBottom	-4107
xlLegendPositionCorner	2
xlLegendPositionLeft	-4131
xlLegendPositionRight	-4152
xlLegendPositionTop	-4160

XlLineStyle

Nome	Valor
xlContinuous	1
xlDash	-4115
xlDashDot	4
xlDashDotDot	5
xlDot	-4118
xlDouble	-4119
Xllinestylenone	-4142
xlSlantDashDot	13

XlLocationInTable

Nome	Valor
xlColumnHeader	-4110
xlColumnItem	5
xlDataHeader	3
xlDataItem	7
xlPageHeader	2
xlPageItem	6
xlRowHeader	-4153
xlRowItem	4
xlTableBody	8

XlMarkerStyle

Nome	Valor
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

Nome	Valor
xlDownward	-4170
xlHorizontal	-4128
xlUpward	-4171
xlVertical	-4166

XlPattern

Nome	Valor
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

Nome	Valor
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

Nome	Valor
xlDate	2
xlNumber	-4145
xlText	-4158

XlPivotFormatType

Nome	Valor
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

Nome	Valor
xlConsolidation	3
xlDatabase	1
xlExternal	2
xlPivotTable	-4148
xlScenario	4

XlQueryType

Nome	Valor
xlADORecordset	7
xlDAORecordset	2
xlODBCQuery	1
xlOLEDBQuery	5
xlTextImport	6
xlWebQuery	4

XlRangeValueDataType

Nome	Valor
xlRangeValueDefault	10
xlRangeValueMSPersistXML	12
xlRangeValueXMLSpreadsheet	11

XlReferenceStyle

Nome	Valor
xlA1	1
xlR1C1	-4150

XlRowCol

Nome	Valor
Xlcolumns	2
Xlrows	1

XlScaleType

Nome	Valor
xlScaleLinear	-4132
xlScaleLogarithmic	-4133

XlSheetType

Nome	Valor
xlChart	-4109
xlDialogSheet	-4116
xlExcel4IntlMacroSheet	4
xlExcel4MacroSheet	3
xlWorksheet	-4167

XlSizeRepresents

Nome	Valor
xlSizeIsArea	1
xlSizeIsWidth	2

XlSubtotalLocationType

Nome	Valor
xlAtBottom	2
xlAtTop	1

XlTickLabelOrientation

Nome	Valor
xlTickLabelOrientationAutomatic	-4105
xlTickLabelOrientationDownward	-4170
xlTickLabelOrientationHorizontal	-4128
xlTickLabelOrientationUpward	-4171
xlTickLabelOrientationVertical	-4166

XlTickLabelPosition

Nome	Valor
xlTickLabelPositionHigh	-4127
xlTickLabelPositionLow	-4134
xlTickLabelPositionNextToAxis	4
xlTickLabelPositionNone	-4142

XlTickMark

Nome	Valor
xlTickMarkCross	4
xlTickMarkInside	2
xlTickMarkNone	-4142
xlTickMarkOutside	3

XlTimeUnit

Nome	Valor
xlDays	0
xlMonths	1
xlYears	2

XlTrendlineType

Nome	Valor
xlExponential	5
xlLinear	-4132
xlLogarithmic	-4133
xlMovingAvg	6
xlPolynomial	3
xlPower	4

XlUnderlineStyle

Nome	Valor
xlUnderlineStyleDouble	-4119
xlUnderlineStyleDoubleAccounting	5
xlUnderlineStyleNone	-4142
xlUnderlineStyleSingle	2
xlUnderlineStyleSingleAccounting	4

XlVAlign

Nome	Valor
xlVAlignBottom	-4107
xlVAlignCenter	-4108
xlVAlignDistributed	-4117
xlVAlignJustify	-4130
xlVAlignTop	-4160

XlWebFormatting

Nome	Valor
xlWebFormattingAll	1
xlWebFormattingNone	3
xlWebFormattingRTF	2

XlWebSelectionType

Nome	Valor
xlAllTables	2
xlEntirePage	1
xlSpecifiedTables	3

XlWindowState

Nome	Valor
xlMaximized	-4137
xlMinimized	-4140
xlNormal	-4143

XlWindowType

Nome	Valor
xlChartAsWindow	5
xlChartInPlace	4
xlClipboard	3
xlInfo	-4129
xlWorkbook	1

Suporte e comentários

Tem dúvidas ou quer enviar comentários sobre o VBA para Office ou sobre esta documentação? Confira Suporte e comentários sobre o VBA para Office a fim de obter orientação sobre as maneiras pelas quais você pode receber suporte e fornecer comentários.