Excel Drawing Objects

Adjustments (1997) Contains a collection of adjustment values for the specified AutoShape, WordArt object, or connector. Each adjustment value represents one way an adjustment handle can be adjusted. Because some adjustment handles can be adjusted in two ways  for instance, some handles can be adjusted both horizontally and vertically  a shape can have more adjustment values than it has adjustment handles. A shape can have up to eight adjustments.

Application
Count
Creator
Item [= setting]
Parent

Border (1995) Represents the border of an object.

Application
Color [= setting]
ColorIndex [= setting]
Creator
LineStyle [= setting]
Parent
Weight [= setting]

Borders (1995) A collection of four Style object.

Application
Color [= setting]
ColorIndex [= setting]
Count
Creator
GetEnumerator()
Item
LineStyle [= setting]
Parent
Value [= setting]
Weight [= setting]

CalloutFormat (1997) Contains properties and methods that apply to line callouts.

Accent [= setting]
Angle [= setting]
Application
AutoAttach [= setting]
AutoLength
AutomaticLength()
Border [= setting]
Creator
CustomDrop(Drop)
CustomLength(Length)
Drop
DropType
Gap [= setting]
Length
Parent
PresetDrop(DropType)
Type [= setting]

ColorFormat (1997) Represents the color of a one-color object, the foreground or background color of an object with a gradient or patterned fill, or the pointer color. You can set colors to an explicit red-green-blue value (by using the SchemeColor property).

Application
Creator
Parent
RGB [= setting]
SchemeColor [= setting]
TintAndShade [= setting]
Type

ConnectorFormat (1995) Contains properties and methods that apply to connectors. A connector is a line that attaches two other shapes at points called connection sites. If you rearrange shapes that are connected, the geometry of the connector will be automatically adjusted so that the shapes remain connected.

Application
BeginConnect(ConnectedShape, ConnectionSite)
BeginConnected
BeginConnectedShape
BeginConnectionSite
BeginDisconnect()
Creator
EndConnect(ConnectedShape, ConnectionSite)
EndConnected
EndConnectedShape
EndConnectionSite
EndDisconnect()
Parent
Type [= setting]

Diagram (2002) Represents a diagram.

Application
AutoFormat [= setting]
AutoLayout [= setting]
Convert(Type)
Creator
FitText()
Nodes
Parent
Reverse [= setting]
Type

DiagramNode (2002) Hidden or unsupported element.

AddNode([pos], [nodeType])
Application
Children
CloneNode(copyChildren, pTargetNode, [pos])
Creator
Delete()
Diagram
Layout [= setting]
MoveNode(pTargetNode, pos)
NextNode()
Parent
PrevNode()
ReplaceNode(pTargetNode)
Root
Shape
SwapNode(pTargetNode, [swapChildren])
TextShape
TransferChildren(pReceivingNode)

DiagramNodeChildren (2002) Hidden or unsupported element.

AddNode([Index], [nodeType])
Application
Count
Creator
FirstChild
GetEnumerator()
Item(Index)
LastChild
Parent
SelectAll()

DiagramNodes (2002) Hidden or unsupported element.

Application
Count
Creator
GetEnumerator()
Item(Index)
Parent
SelectAll()

FillFormat (1997) Represents fill formatting for a shape. A shape can have a solid, gradient, texture, pattern, picture, or semi-transparent fill.

Application
BackColor [= setting]
Background()
Creator
ForeColor [= setting]
GradientColorType
GradientDegree
GradientStyle
GradientVariant
OneColorGradient(Style, Variant, Degree)
Parent
Pattern
Patterned(Pattern)
PresetGradient(Style, Variant, PresetGradientType)
PresetGradientType
PresetTexture
PresetTextured(PresetTexture)
Solid()
TextureName
TextureType
Transparency [= setting]
TwoColorGradient(Style, Variant)
Type
UserPicture(PictureFile)
UserTextured(TextureFile)
Visible [= setting]

FreeformBuilder (1997) Represents the geometry of a freeform while its being built.

AddNodes(SegmentType, EditingType, X1, Y1, [X2], [Y2], [X3], [Y3])
Application
ConvertToShape()
Creator
Parent

GroupShapes (1997) Represents the individual shapes within a grouped shape. Each shape is represented by a Item method with this object, you can work with single shapes within a group without having to ungroup them.

Application
Count
Creator
GetEnumerator()
Item(Index)
Parent
Range

Interior (1995) Represents the interior of an object.

Application
Color [= setting]
ColorIndex [= setting]
Creator
InvertIfNegative [= setting]
Parent
Pattern [= setting]
PatternColor [= setting]
PatternColorIndex [= setting]

LineFormat (1997) Represents line and arrowhead formatting. For a line, the LineFormat object contains formatting information for the line itself; for a shape with a border, this object contains formatting information for the shape border.

Application
BackColor [= setting]
BeginArrowheadLength [= setting]
BeginArrowheadStyle [= setting]
BeginArrowheadWidth [= setting]
Creator
DashStyle [= setting]
EndArrowheadLength [= setting]
EndArrowheadStyle [= setting]
EndArrowheadWidth [= setting]
ForeColor [= setting]
Parent
Pattern [= setting]
Style [= setting]
Transparency [= setting]
Visible [= setting]
Weight [= setting]

LinkFormat (1995) Contains linked OLE object properties.

Application
AutoUpdate [= setting]
Creator
Locked [= setting]
Parent
Update()

PictureFormat (1997) Contains properties and methods that apply to pictures and OLE objects. The OLEFormat object contains properties and methods that apply to OLE objects whether or not theyre linked.

Application
Brightness [= setting]
ColorType [= setting]
Contrast [= setting]
Creator
CropBottom [= setting]
CropLeft [= setting]
CropRight [= setting]
CropTop [= setting]
IncrementBrightness(Increment)
IncrementContrast(Increment)
Parent
TransparencyColor [= setting]
TransparentBackground [= setting]

Point (1995) Represents a single point in a series in a chart. The Point object is a member of the Points collection. The Points collection contains all the points in one series.

Application
ApplyDataLabels([Type], [LegendKey], [AutoText], [HasLeaderLines], [ShowSeriesName], [ShowCategoryName], [ShowValue], [ShowPercentage], [ShowBubbleSize], [Separator])
ApplyPictToEnd [= setting]
ApplyPictToFront [= setting]
ApplyPictToSides [= setting]
Border
ClearFormats()
Copy()
Creator
DataLabel
Delete()
Explosion [= setting]
Fill
HasDataLabel [= setting]
Interior
InvertIfNegative [= setting]
MarkerBackgroundColor [= setting]
MarkerBackgroundColorIndex [= setting]
MarkerForegroundColor [= setting]
MarkerForegroundColorIndex [= setting]
MarkerSize [= setting]
MarkerStyle [= setting]
Parent
Paste()
PictureType [= setting]
PictureUnit [= setting]
SecondaryPlot [= setting]
Select()
Shadow [= setting]

Points (1995) A collection of all the Point objects in the specified series in a chart.

Application
Count
Creator
GetEnumerator()
Item(Index)
Parent

ShadowFormat (1997) Represents shadow formatting for a shape.

Application
Creator
ForeColor [= setting]
IncrementOffsetX(Increment)
IncrementOffsetY(Increment)
Obscured [= setting]
OffsetX [= setting]
OffsetY [= setting]
Parent
Transparency [= setting]
Type [= setting]
Visible [= setting]

Shape (1997) Represents an object in the drawing layer, such as an AutoShape, freeform, OLE object, or picture. The Shape object is a member of the Shapes collection. The Shapes collection contains all the shapes on a slide.

Adjustments
AlternativeText [= setting]
Application
Apply()
AutoShapeType [= setting]
BlackWhiteMode [= setting]
BottomRightCell
Callout
CanvasCropBottom(Increment)
CanvasCropLeft(Increment)
CanvasCropRight(Increment)
CanvasCropTop(Increment)
CanvasItems
Child
ConnectionSiteCount
Connector
ConnectorFormat
ControlFormat
Copy()
CopyPicture([Appearance], [Format])
Creator
Cut()
Delete()
Diagram
DiagramNode
DrawingObject
Duplicate()
Fill
Flip(FlipCmd)
FormControlType
GroupItems
HasDiagram
HasDiagramNode
Height [= setting]
HorizontalFlip
Hyperlink
ID
IncrementLeft(Increment)
IncrementRotation(Increment)
IncrementTop(Increment)
Left [= setting]
Line
LinkFormat
LockAspectRatio [= setting]
Locked [= setting]
Name [= setting]
Nodes
OLEFormat
OnAction [= setting]
Parent
ParentGroup
PickUp()
PictureFormat
Placement [= setting]
RerouteConnections()
Rotation [= setting]
ScaleHeight(Factor, RelativeToOriginalSize, [Scale])
ScaleWidth(Factor, RelativeToOriginalSize, [Scale])
Script
Select([Replace])
SetShapesDefaultProperties()
Shadow
TextEffect
TextFrame
ThreeD
Top [= setting]
TopLeftCell
Type
Ungroup()
VerticalFlip
Vertices
Visible [= setting]
Width [= setting]
ZOrder(ZOrderCmd)
ZOrderPosition

ShapeNode (1997) Represents the geometry and the geometry-editing properties of the nodes in a user-defined freeform. Nodes include the vertices between the segments of the freeform and the control points for curved segments. The ShapeNode object is a member of the ShapeNodes collection. The ShapeNodes collection contains all the nodes in a freeform.

Application
Creator
EditingType
Parent
Points
SegmentType

ShapeNodes (1997) A collection of all the ConvertToShape methods.

Application
Count
Creator
Delete(Index)
GetEnumerator()
Insert(Index, SegmentType, EditingType, X1, Y1, [X2], [Y2], [X3], [Y3])
Item(Index)
Parent
SetEditingType(Index, EditingType)
SetPosition(Index, X1, Y1)
SetSegmentType(Index, SegmentType)

ShapeRange (1997) Represents a shape range, which is a set of shapes on a document. A shape range can contain as few as a single shape or as many as all the shapes on the document. You can include whichever shapes you want  chosen from among all the shapes on the document or all the shapes in the selection  to construct a shape range. For example, you could construct a ShapeRange collection that contains the first three shapes on a document, all the selected shapes on a document, or all the freeforms on a document.

Adjustments
Align(AlignCmd, RelativeTo)
AlternativeText [= setting]
Application
Apply()
AutoShapeType [= setting]
BlackWhiteMode [= setting]
Callout
CanvasCropBottom(Increment)
CanvasCropLeft(Increment)
CanvasCropRight(Increment)
CanvasCropTop(Increment)
CanvasItems
Child
ConnectionSiteCount
Connector
ConnectorFormat
Count
Creator
Delete()
Diagram
DiagramNode
Distribute(DistributeCmd, RelativeTo)
Duplicate()
Fill
Flip(FlipCmd)
GetEnumerator()
Group()
GroupItems
HasDiagram
HasDiagramNode
Height [= setting]
HorizontalFlip
ID
IncrementLeft(Increment)
IncrementRotation(Increment)
IncrementTop(Increment)
Item(Index)
Left [= setting]
Line
LockAspectRatio [= setting]
Name [= setting]
Nodes
Parent
ParentGroup
PickUp()
PictureFormat
Regroup()
RerouteConnections()
Rotation [= setting]
ScaleHeight(Factor, RelativeToOriginalSize, [Scale])
ScaleWidth(Factor, RelativeToOriginalSize, [Scale])
Select([Replace])
SetShapesDefaultProperties()
Shadow
TextEffect
TextFrame
ThreeD
Top [= setting]
Type
Ungroup()
VerticalFlip
Vertices
Visible [= setting]
Width [= setting]
ZOrder(ZOrderCmd)
ZOrderPosition

Shapes (1997) A collection of all the Shape objects on the specified sheet. Each Shape object represents an object in the drawing layer, such as an AutoShape, freeform, OLE object, or picture.

AddCallout(Type, Left, Top, Width, Height)
AddCanvas(Left, Top, Width, Height)
AddConnector(Type, BeginX, BeginY, EndX, EndY)
AddCurve(SafeArrayOfPoints)
AddDiagram(Type, Left, Top, Width, Height)
AddFormControl(Type, Left, Top, Width, Height)
AddLabel(Orientation, Left, Top, Width, Height)
AddLine(BeginX, BeginY, EndX, EndY)
AddOLEObject([ClassType], [Filename], [Link], [DisplayAsIcon], [IconFileName], [IconIndex], [IconLabel], [Left], [Top], [Width], [Height])
AddPicture(Filename, LinkToFile, SaveWithDocument, Left, Top, Width, Height)
AddPolyline(SafeArrayOfPoints)
AddShape(Type, Left, Top, Width, Height)
AddTextbox(Orientation, Left, Top, Width, Height)
AddTextEffect(PresetTextEffect, Text, FontName, FontSize, FontBold, FontItalic, Left, Top)
Application
BuildFreeform(EditingType, X1, Y1)
Count
Creator
GetEnumerator()
Item(Index)
Parent
Range
SelectAll()

TextEffectFormat (1997) Contains properties and methods that apply to WordArt objects.

Alignment [= setting]
Application
Creator
FontBold [= setting]
FontItalic [= setting]
FontName [= setting]
FontSize [= setting]
KernedPairs [= setting]
NormalizedHeight [= setting]
Parent
PresetShape [= setting]
PresetTextEffect [= setting]
RotatedChars [= setting]
Text [= setting]
ToggleVerticalText()
Tracking [= setting]

TextFrame (1997) Represents the text frame in a Shape object. Contains the text in the text frame as well as the properties and methods that control the alignment and anchoring of the text frame.

Application
AutoMargins [= setting]
AutoSize [= setting]
Characters([Start], [Length])
Creator
HorizontalAlignment [= setting]
MarginBottom [= setting]
MarginLeft [= setting]
MarginRight [= setting]
MarginTop [= setting]
Orientation [= setting]
Parent
ReadingOrder [= setting]
VerticalAlignment [= setting]

ThreeDFormat (1997) Represents three-dimensional formatting of a shape.

Application
Creator
Depth [= setting]
ExtrusionColor
ExtrusionColorType [= setting]
IncrementRotationX(Increment)
IncrementRotationY(Increment)
Parent
Perspective [= setting]
PresetExtrusionDirection
PresetLightingDirection [= setting]
PresetLightingSoftness [= setting]
PresetMaterial [= setting]
PresetThreeDFormat
ResetRotation()
RotationX [= setting]
RotationY [= setting]
SetExtrusionDirection(PresetExtrusionDirection)
SetThreeDFormat(PresetThreeDFormat)
Visible [= setting]