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 |
| 名稱 |
值 |
| 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
| 名稱 |
值 |
| xlHundred並排 |
-8 |
| xlHundreds |
-2 |
| xlHundredThousands |
-5 |
| xl][圖表][圖表] |
-10 |
| xl並排 |
-6 |
| xlTen並排 |
-7 |
| xlTenThousands |
-4 |
| xlThousand並排 |
-9 |
| xlThousands |
-3 |
XlEndStyleCap
XlErrorBarDirection
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 |
| 名稱 |
值 |
| 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 |
| 名稱 |
值 |
| 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
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 |
| 名稱 |
值 |
| 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 支援與意見反應。