(Graph Visual Basic 参考) 的枚举

本主题提供 Graph 对象模型中的所有枚举的列表。

有关更详细的说明,请参阅以下内容:

XlArabicModes

名称
xlArabicBothStrict 3
xlArabicNone 0
xlArabicStrictAlefHamza 1
xlArabicStrictFinalYaa 2

XlArrowHeadLength

名称
xlArrowHeadLengthLong 3
xlArrowHeadLengthMedium -4138
xlArrowHeadLengthShort 1

XlArrowHeadStyle

名称
xlArrowHeadStyleClosed 3
xlArrowHeadStyleDoubleClosed 5
xlArrowHeadStyleDoubleOpen 4
xlArrowHeadStyleNone -4142
xlArrowHeadStyleOpen 2

XlArrowHeadWidth

名称
xlArrowHeadWidthMedium -4138
xlArrowHeadWidthNarrow 1
xlArrowHeadWidthWide 3

XlAxisCrosses

名称
xlAxisCrossesAutomatic -4105
xlAxisCrossesCustom -4114
xlAxisCrossesMaximum 2
xlAxisCrossesMinimum 4

XlAxisGroup

名称
xlPrimary 1
xlSecondary 2

XlAxisType

名称
xlCategory 1
xlSeriesAxis 3
xlValue 2

XlBackground

名称
xlBackgroundAutomatic -4105
xlBackgroundOpaque 3
xlBackgroundTransparent 2

XlBarShape

名称
xlBox 0
xlConeToMax 5
xlConeToPoint 4
xlCylinder 3
xlPyramidToMax 2
xlPyramidToPoint 1

XlBorderWeight

名称
xlHairline 1
xlMedium -4138
xlThick 4
xlThin 2

XlCalculatedMemberType

名称
xlCalculatedMember 0
xlCalculatedSet 1

XlCategoryType

名称
xlAutomaticScale -4105
xlCategoryScale 2
xlTimeScale 3

XlChartGallery

名称
xlAnyGallery 23
xlBuiltIn 21
xlUserDefined 22

XlChartItem

名称
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

名称
xlAllFaces 7
xlEnd 2
xlEndSides 3
xlFront 4
xlFrontEnd 6
xlFrontSides 5
xlSides 1

XlChartPictureType

名称
xlStack 2
xlStackScale 3
xlStretch 1

XlChartSplitType

名称
xlSplitByCustomSplit 4
xlSplitByPercentValue 3
xlSplitByPosition 1
xlSplitByValue 2

XlChartType

名称
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

名称
xlCmdCube 1
xlCmdDefault 4
xlCmdList 5
xlCmdSql 2
xlCmdTable 3

XlColorIndex

名称
xlColorIndexAutomatic -4105
xlColorIndexNone -4142

XlColumnDataType

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

XlConsolidationFunction

名称
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

名称
xlBitmap 2
xlPicture -4147

XlCreator

名称
xlCreatorCode 1480803660

XlCubeFieldType

名称
xlHierarchy 1
xlMeasure 2
xlSet 3

XlDataLabelPosition

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

XlDataLabelSeparator

名称
xlDataLabelSeparatorDefault 1

XlDataLabelsType

名称
xlDataLabelsShowBubbleSizes 6
xlDataLabelsShowLabel 4
xlDataLabelsShowLabelAndPercent 5
xlDataLabelsShowNone -4142
xlDataLabelsShowPercent 3
xlDataLabelsShowValue 2

XlDataSeriesDate

名称
xlDay 1
xlMonth 3
xlWeekday 2
xlYear 4

XlDataSeriesType

名称
xlAutoFill 4
xlChronological 3
xlDataSeriesLinear -4132
xlGrowth 2

XlDeleteShiftDirection

名称
xlShiftToLeft -4159
xlShiftUp -4162

XlDirection

名称
xlDown -4121
xlToLeft -4159
xlToRight -4161
xlUp -4162

XlDisplayBlanksAs

名称
xlInterpolated 3
xlNotPlotted 1
xlZero 2

XlDisplayDrawingObjects

名称
xlDisplayShapes -4104
xlHide 3
xlPlaceholders 2

XlDisplayUnit

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

XlEndStyleCap

名称
xlCap 1
xlNoCap 2

XlErrorBarDirection

名称
xlX -4168
xlY 1

XlErrorBarInclude

名称
xlErrorBarIncludeBoth 1
xlErrorBarIncludeMinusValues 3
xlErrorBarIncludeNone -4142
xlErrorBarIncludePlusValues 2

XlErrorBarType

名称
xlErrorBarTypeCustom -4114
xlErrorBarTypeFixedValue 1
xlErrorBarTypePercent 2
xlErrorBarTypeStDev -4155
xlErrorBarTypeStError 4

XlFindLookIn

名称
xlComments -4144
xlFormulas -4123
xlValues -4163

XlHAlign

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

XlHebrewModes

名称
xlHebrewFullScript 0
xlHebrewMixedAuthorizedScript 3
xlHebrewMixedScript 2
xlHebrewPartialScript 1

XlImportDataAs

名称
xlPivotTableReport 1
xlQueryTable 0

XlInsertFormatOrigin

名称
xlFormatFromLeftOrAbove 0
xlFormatFromRightOrBelow 1

XlInsertShiftDirection

名称
xlShiftDown -4121
xlShiftToRight -4161

XlLegendPosition

名称
xlLegendPositionBottom -4107
xlLegendPositionCorner 2
xlLegendPositionLeft -4131
xlLegendPositionRight -4152
xlLegendPositionTop -4160

XlLineStyle

名称
xlContinuous 1
xlDash -4115
xlDashDot 4
xlDashDotDot 5
xlDot -4118
xlDouble -4119
xlLineStyleNone -4142
xlSlantDashDot 13

XlLocationInTable

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

XlMarkerStyle

名称
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

名称
xlDownward -4170
xlHorizontal -4128
xlUpward -4171
xlVertical -4166

XlPattern

名称
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

名称
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

名称
xlDate 2
xlNumber -4145
xlText -4158

XlPivotFormatType

名称
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

名称
xlConsolidation 3
xlDatabase 1
xlExternal 2
xlPivotTable -4148
xlScenario 4

XlQueryType

名称
xlADORecordset 7
xlDAORecordset 2
xlODBCQuery 1
xlOLEDBQuery 5
xlTextImport 6
xlWebQuery 4

XlRangeValueDataType

名称
xlRangeValueDefault 10
xlRangeValueMSPersistXML 12
xlRangeValueXMLSpreadsheet 11

XlReferenceStyle

名称
xlA1 1
xlR1C1 -4150

XlRowCol

名称
xlColumns 2
xlRows 1

XlScaleType

名称
xlScaleLinear -4132
xlScaleLogarithmic -4133

XlSheetType

名称
xlChart -4109
xlDialogSheet -4116
xlExcel4IntlMacroSheet 4
xlExcel4MacroSheet 3
xlWorksheet -4167

XlSizeRepresents

名称
xlSizeIsArea 1
xlSizeIsWidth 2

XlSubtotalLocationType

名称
xlAtBottom 2
xlAtTop 1

XlTickLabelOrientation

名称
xlTickLabelOrientationAutomatic -4105
xlTickLabelOrientationDownward -4170
xlTickLabelOrientationHorizontal -4128
xlTickLabelOrientationUpward -4171
xlTickLabelOrientationVertical -4166

XlTickLabelPosition

名称
xlTickLabelPositionHigh -4127
xlTickLabelPositionLow -4134
xlTickLabelPositionNextToAxis 4
xlTickLabelPositionNone -4142

XlTickMark

名称
xlTickMarkCross 4
xlTickMarkInside 2
xlTickMarkNone -4142
xlTickMarkOutside 3

XlTimeUnit

名称
xlDays 0
xlMonths 1
xlYears 2

XlTrendlineType

名称
xlExponential 5
xlLinear -4132
xlLogarithmic -4133
xlMovingAvg 6
xlPolynomial 3
xlPower 4

XlUnderlineStyle

名称
xlUnderlineStyleDouble -4119
xlUnderlineStyleDoubleAccounting 5
xlUnderlineStyleNone -4142
xlUnderlineStyleSingle 2
xlUnderlineStyleSingleAccounting 4

XlVAlign

名称
xlVAlignBottom -4107
xlVAlignCenter -4108
xlVAlignDistributed -4117
xlVAlignJustify -4130
xlVAlignTop -4160

XlWebFormatting

名称
xlWebFormattingAll 1
xlWebFormattingNone 3
xlWebFormattingRTF 2

XlWebSelectionType

名称
xlAllTables 2
xlEntirePage 1
xlSpecifiedTables 3

XlWindowState

名称
xlMaximized -4137
xlMinimized -4140
xlNormal -4143

XlWindowType

名称
xlChartAsWindow 5
xlChartInPlace 4
xlClipboard 3
xlInfo -4129
xlWorkbook 1

支持和反馈

有关于 Office VBA 或本文档的疑问或反馈? 请参阅 Office VBA 支持和反馈,获取有关如何接收支持和提供反馈的指南。