Enumerated Set Definitions

Set Name Possible Values
3DEffect 2D, 3D
Anchor TopLeft, TopCenter, TopRight, MiddleLeft, MiddleCenter, MiddleRight, BottomLeft, BottomCenter, BottomRight
Boolean True, Yes, False, No
BorderType None, Thin, DoubleThin,ThinOutsideRegularInside, Regular, RegularOutsideThinInside, Thick
BubbleType None, 3D, Fill, Outline, OutlineAndFill
BubbleValueAs (4.0.3+) Area, Width
CategoryLabelAdjustment AsNeeded, Always
Color Black, Blue, Cyan, Darkgray, Gray, Green, Lightgray, Magenta, Orange, Pink, Red, White, Yellow, {#rrggbb}, {#rrggbbaa}
DataImportMethod Replace, Append, LinkByRow, LinkByColumn, AddFilters
DDHighlightMode BoldOutline, Outline, ColorChange
DivideBy Auto, Unchanged, Percentage, Thousands, Millions, Billions, Trillions
DLBackgroundType Transparent, Color
DLPosition (4.0 only) InsideTop, OutsideTop, InsideBottom, Inside, Outside, OutsideWithLeader, OutsideWithLeaderOnSides
DLPosition (4.0.1+) Inside, InsideLeft, Inside Right, InsideTop, InsideBottom, Out, OutsideTop, OutsideRight, OutsideWithLeader, OutsideWithLeaderOnSides, Above, Below
FontName Courier, Helvetica, TimesRoman, {OtherName}
FontStyle Plain, Bold, Italic, BoldItalic/ItalicBold
Gauge LabelPosition LeftRight, TopBottom
Gauge LabelSizing Automatically, Manually
GradientType None, LeftRight, RightLeft, TopBottom, BottomTop
GraphSubType Basic, Horizontal, Stacked, Horizontal Stacked, Scatter, HighLowOpenClose, CandleStick, Combo, Dual Y, Bulb, LED Bar, Filled Bar, 3D Bulb
GraphType Bar, Area, Line, XY, Pie, Stock, Line Bar, Time, Radar, Pareto, Gauge
HJustification Left, Center, Right
ImageType (4.0.1+) PopChartLossLess,JPEG
MarkerPosition X, Y, Value, SValue, Time, Y2 (4.0.1+)
MarkerType Range, Line
NegativeDisplayType MinusSign, Paranthesis, AbsoluteValue
NoteLayout Default, OutsideInVertical, InsideOutVertical
NumberFormat General, Currency, Percent, Date, HourM, HourMS
OutlineType None, Color, Beveled, Darker, Lighter
OutputType FlashWithFallback, SVGWithFallback, Flash, SVG, GIF
PercentageType None, Category, Total
ScalePosition Left, Right, Bottom, Top
SeriesTextType (4.0 only) TextOnly, TextAndValue, TextOutValueIn, TextAboveVOG, TextBelowVOG, TextAVAbove, TextAVBelow, NotSet
SeriesTextType (4.0.1+) ValueOnly, NameOnly, NameAndValue, NameOutsideValueInside, NameAboveValueOnGraph, NameBelowValueOnGraph, NameAndValueAbove, NameAndValueBelow
ShadowType None, 1, 2, 3, 4, 5, 6
SymbolType None, SmallSquare, Dot, Square, SquareOutliine, Circle, CircleOutline, Triangle, TriangelOutline, Plus, PlusOutline, Diamond, DiamondOutline
TickDirection Outside, Inside, Cross
TickSize Small, Medium, Large
ValueScaleSizing Automatically, Manually
ValueScaleType Line, Bar, Left, Right
WeekDay Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday