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]
Width [= setting]

LegendEntries (1995) A collection of all the LegendKey object.

Application
Count
Creator
GetEnumerator()
Item(Index)
Parent

LegendEntry (1995) Represents a legend entry in a chart legend. The LegendEntry object is a member of the LegendEntries collection. The LegendEntries collection contains all the LegendEntry objects in the legend.

Application
AutoScaleFont [= setting]
Creator
Delete()
Font
Height
Index
Left
LegendKey
Parent
Select()
Top
Width

LegendKey (1995) Represents a legend key in a chart legend. Each legend key is a graphic that visually links a legend entry with its associated series or trendline in the chart. The legend key is linked to its associated series or trendline in such a way that changing the formatting of one simultaneously changes the formatting of the other.

Application
Border
ClearFormats()
Creator
Delete()
Fill
Height
Interior
InvertIfNegative [= setting]
Left
MarkerBackgroundColor [= setting]
MarkerBackgroundColorIndex [= setting]
MarkerForegroundColor [= setting]
MarkerForegroundColorIndex [= setting]
MarkerSize [= setting]
MarkerStyle [= setting]
Parent
PictureType [= setting]
PictureUnit [= setting]
Select()
Shadow [= setting]
Smooth [= setting]
Top
Width

PlotArea (1995) Represents the plot area of a chart. This is the area where your chart data is plotted. The plot area on a 2-D chart contains the data markers, gridlines, data labels, trendlines, and optional chart items placed in the chart area. The plot area on a 3-D chart contains all the above items plus the walls, floor, axes, axis titles, and tick-mark labels in the chart.

Application
Border
ClearFormats()
Creator
Fill
Height [= setting]
InsideHeight
InsideLeft
InsideTop
InsideWidth
Interior
Left [= setting]
Name
Parent
Select()
Top [= setting]
Width [= setting]

TickLabels (1995) Represents the tick-mark labels associated with tick marks on a chart axis. This object isnt a collection. Theres no object that represents a single tick-mark label; you must return all the tick-mark labels as a unit.

Alignment [= setting]
Application
AutoScaleFont [= setting]
Creator
Delete()
Depth
Font
Name
NumberFormat [= setting]
NumberFormatLinked [= setting]
NumberFormatLocal [= setting]
Offset [= setting]
Orientation [= setting]
Parent
ReadingOrder [= setting]
Select()

Trendline (1995) Represents a trendline in a chart. A trendline shows the trend, or direction, of data in a series. The Trendline object is a member of the Trendlines collection. The Trendlines collection contains all the Trendline objects for a single series.

Application
Backward [= setting]
Border
ClearFormats()
Creator
DataLabel
Delete()
DisplayEquation [= setting]
DisplayRSquared [= setting]
Forward [= setting]
Index
Intercept [= setting]
InterceptIsAuto [= setting]
Name [= setting]
NameIsAuto [= setting]
Order [= setting]
Parent
Period [= setting]
Select()
Type [= setting]

Trendlines (1995) A collection of all the Trendline objects for the specified series. Each Trendline object represents a trendline in a chart. A trendline shows the trend, or direction, of data in a series.

Add([Type], [Order], [Period], [Forward], [Backward], [Intercept], [DisplayEquation], [DisplayRSquared], [Name])
Application
Count
Creator
GetEnumerator()
Item([Index])
Parent

UpBars (1995) Represents the up bars in a chart group. Up bars connect points on series one with higher values on the last series in the chart group (the lines go up from series one). Only 2-D line groups that contain at least two series can have up bars. This object isnt a collection. Theres no object that represents a single up bar; you either have up 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()

Walls (1995) Represents the walls of a 3-D chart. This object isnt a collection. Theres no object that represents a single wall; you must return all the walls as a unit.

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