Excel Chart Appearance Objects

ChartColorFormat (1997) Used only with charts. Represents the color of a one-color object or the foreground or background color of an object with a gradient or patterned fill.

Application
Creator
Parent
RGB
SchemeColor [= setting]
Type

ChartFillFormat (1997) Used only with charts. Represents fill formatting for chart elements.

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

Corners (1995) Represents the corners of a 3-D chart. This object isnt a collection.

Application
Creator
Name
Parent
Select()

DataLabel (1995) Represents the data label on a chart point or trendline. On a series, the DataLabel object is a member of the DataLabels collection. The DataLabels collection contains a DataLabel object for each point. For a series without definable points (such as an area series), the DataLabels collection contains a single DataLabel object.

Application
AutoScaleFont [= setting]
AutoText [= setting]
Border
Caption [= setting]
Characters
Creator
Delete()
Fill
Font
HorizontalAlignment [= setting]
Interior
Left [= setting]
Name
NumberFormat [= setting]
NumberFormatLinked [= setting]
NumberFormatLocal [= setting]
Orientation [= setting]
Parent
Position [= setting]
ReadingOrder [= setting]
Select()
Separator [= setting]
Shadow [= setting]
ShowBubbleSize [= setting]
ShowCategoryName [= setting]
ShowLegendKey [= setting]
ShowPercentage [= setting]
ShowSeriesName [= setting]
ShowValue [= setting]
Text [= setting]
Top [= setting]
Type [= setting]
VerticalAlignment [= setting]

DataLabels (1995) A collection of all the DataLabel objects for the specified series. Each DataLabel object represents a data label for a point or trendline. For a series without definable points (such as an area series), the DataLabels collection contains a single data label.

Application
AutoScaleFont [= setting]
AutoText [= setting]
Border
Count
Creator
Delete()
Fill
Font
GetEnumerator()
HorizontalAlignment [= setting]
Interior
Item(Index)
Name
NumberFormat [= setting]
NumberFormatLinked [= setting]
NumberFormatLocal [= setting]
Orientation [= setting]
Parent
Position [= setting]
ReadingOrder [= setting]
Select()
Separator [= setting]
Shadow [= setting]
ShowBubbleSize [= setting]
ShowCategoryName [= setting]
ShowLegendKey [= setting]
ShowPercentage [= setting]
ShowSeriesName [= setting]
ShowValue [= setting]
Type [= setting]
VerticalAlignment [= setting]

DownBars (1995) Represents the down bars in a chart group. Down bars connect points on the first series in the chart group with lower values on the last series (the lines go down from the first series). Only 2-D line groups that contain at least two series can have down bars. This object isnt a collection. Theres no object that represents a single down bar; you either have up bars and down bars turned on for all points in a chart group or you have them turned off.

Application
Border
Creator
Delete()
Fill
Interior
Name
Parent
Select()

DropLines (1995) Represents the drop lines in a chart group. Drop lines connect the points in the chart with the x-axis. Only line and area chart groups can have drop lines. This object isnt a collection. Theres no object that represents a single drop line; you either have drop lines turned on for all points in a chart group or you have them turned off.

Application
Border
Creator
Delete()
Name
Parent
Select()

ErrorBars (1995) Represents the error bars on a chart series. Error bars indicate the degree of uncertainty for chart data. Only series in area, bar, column, line, and scatter groups on a 2-D chart can have error bars. Only series in scatter groups can have x and y error bars. This object isnt a collection. Theres no object that represents a single error bar; you either have x error bars or y error bars turned on for all points in a series or you have them turned off.

Application
Border
ClearFormats()
Creator
Delete()
EndStyle [= setting]
Name
Parent
Select()

Floor (2000) Represents the floor of a 3-D chart

Application
Border
ClearFormats()
Creator
Fill
Interior
Name
Parent
Paste()
PictureType [= setting]
Select()

Gridlines (1995) Represents major or minor gridlines on a chart axis. Gridlines extend the tick marks on a chart axis to make it easier to see the values associated with the data markers. This object isnt a collection. Theres no object that represents a single gridline; you either have all gridlines for an axis turned on or all of them turned off.

Application
Border
Creator
Delete()
Name
Parent
Select()

HiLoLines (1995) Represents the high-low lines in a chart group. High-low lines connect the highest point with the lowest point in every category in the chart group. Only 2-D line groups can have high-low lines. This object isnt a collection. Theres no object that represents a single high-low line; you either have high-low lines turned on for all points in a chart group or you have them turned off.

Application
Border
Creator
Delete()
Name
Parent
Select()

LeaderLines (1997) Represents leader lines on a chart. Leader lines connect data labels to data points. This object isnt a collection; theres no object that represents a single leader line.

Application
Border
Creator
Delete()
Parent
Select()

Legend (1995) Represents the legend in a chart. Each chart can have only one legend. The Legend object contains one or more LegendKey object.

Application
AutoScaleFont [= setting]
Border
Clear()
Creator
Delete()
Fill
Font
Height [= setting]
Interior
Left [= setting]
LegendEntries([Index])
Name
Parent
Position [= setting]
Select()
Shadow [= setting]
Top [= setting]