Excel Chart Objects

Axes (1995) A collection of all the Axis objects in the specified chart.

Application
Count
Creator
GetEnumerator()
Item(Type, [AxisGroup])
Parent

Axis (1995) Represents a single axis in a chart. The Axis object is a member of the Axes collection.

Application
AxisBetweenCategories [= setting]
AxisGroup
AxisTitle
BaseUnit [= setting]
BaseUnitIsAuto [= setting]
Border
CategoryNames [= setting]
CategoryType [= setting]
Creator
Crosses [= setting]
CrossesAt [= setting]
Delete()
DisplayUnit [= setting]
DisplayUnitCustom [= setting]
DisplayUnitLabel
HasDisplayUnitLabel [= setting]
HasMajorGridlines [= setting]
HasMinorGridlines [= setting]
HasTitle [= setting]
Height
Left
MajorGridlines
MajorTickMark [= setting]
MajorUnit [= setting]
MajorUnitIsAuto [= setting]
MajorUnitScale [= setting]
MaximumScale [= setting]
MaximumScaleIsAuto [= setting]
MinimumScale [= setting]
MinimumScaleIsAuto [= setting]
MinorGridlines
MinorTickMark [= setting]
MinorUnit [= setting]
MinorUnitIsAuto [= setting]
MinorUnitScale [= setting]
Parent
ReversePlotOrder [= setting]
ScaleType [= setting]
Select()
TickLabelPosition [= setting]
TickLabels
TickLabelSpacing [= setting]
TickMarkSpacing [= setting]
Top
Type [= setting]
Width

AxisTitle (1995) Represents a chart axis title.

Application
AutoScaleFont [= setting]
Border
Caption [= setting]
Characters
Creator
Delete()
Fill
Font
HorizontalAlignment [= setting]
Interior
Left [= setting]
Name
Orientation [= setting]
Parent
ReadingOrder [= setting]
Select()
Shadow [= setting]
Text [= setting]
Top [= setting]
VerticalAlignment [= setting]

Chart (1995) Represents a chart in a workbook. The chart can be either an embedded chart (contained in a ChartObject) or a separate chart sheet.

Activate()
Application
ApplyCustomType(ChartType, [TypeName])
ApplyDataLabels([Type], [LegendKey], [AutoText], [HasLeaderLines], [ShowSeriesName], [ShowCategoryName], [ShowValue], [ShowPercentage], [ShowBubbleSize], [Separator])
Arcs([Index])
Area3DGroup
AreaGroups([Index])
AutoFormat(Gallery, [Format])
AutoScaling [= setting]
Axes([Type], [AxisGroup])
Bar3DGroup
BarGroups([Index])
BarShape [= setting]
BeforeDoubleClick
BeforeRightClick
Buttons([Index])
Calculate
ChartArea
ChartEvents_Event_Activate
ChartEvents_Event_Select
ChartGroups([Index])
ChartObjects([Index])
ChartTitle
ChartType [= setting]
ChartWizard([Source], [Gallery], [Format], [PlotBy], [CategoryLabels], [SeriesLabels], [HasLegend], [Title], [CategoryTitle], [ValueTitle], [ExtraTitle])
CheckBoxes([Index])
CheckSpelling([CustomDictionary], [IgnoreUppercase], [AlwaysSuggest], [SpellLang])
CodeName
Column3DGroup
ColumnGroups([Index])
Copy([Before], [After])
CopyChartBuild()
CopyPicture([Appearance], [Format], [Size])
Corners
CreateObjRef(requestedType)
CreatePublisher([Edition], [Appearance], [Size], [ContainsPICT], [ContainsBIFF], [ContainsRTF], [ContainsVALU])
Creator
DataTable
Deactivate
Delete()
DepthPercent [= setting]
Deselect()
DisplayBlanksAs [= setting]
DoughnutGroups([Index])
DragOver
DragPlot
DrawingObjects([Index])
Drawings([Index])
DropDowns([Index])
Elevation [= setting]
Equals(obj)
Evaluate(Name)
Export(Filename, [FilterName], [Interactive])
Floor
GapDepth [= setting]
GetChartElement(x, y, ElementID, Arg1, Arg2)
GetHashCode()
GetLifetimeService()
GetType()
GroupBoxes([Index])
GroupObjects([Index])
HasAxis [= setting]
HasDataTable [= setting]
HasLegend [= setting]
HasPivotFields [= setting]
HasTitle [= setting]
HeightPercent [= setting]
Hyperlinks
Index
InitializeLifetimeService()
Labels([Index])
Legend
Line3DGroup
LineGroups([Index])
Lines([Index])
ListBoxes([Index])
Location(Where, [Name])
MailEnvelope
MouseDown
MouseMove
MouseUp
Move([Before], [After])
Name [= setting]
Next
OLEObjects([Index])
OnDoubleClick [= setting]
OnSheetActivate [= setting]
OnSheetDeactivate [= setting]
OptionButtons([Index])
Ovals([Index])
PageSetup
Parent
Paste([Type])
Perspective [= setting]
Pictures([Index])
Pie3DGroup
PieGroups([Index])
PivotLayout
PlotArea
PlotBy [= setting]
PlotVisibleOnly [= setting]
Previous
PrintOut([From], [To], [Copies], [Preview], [ActivePrinter], [PrintToFile], [Collate], [PrToFileName])
PrintPreview([EnableChanges])
Protect([Password], [DrawingObjects], [Contents], [Scenarios], [UserInterfaceOnly])
ProtectContents
ProtectData [= setting]
ProtectDrawingObjects
ProtectFormatting [= setting]
ProtectGoalSeek [= setting]
ProtectionMode
ProtectSelection [= setting]
RadarGroups([Index])
Rectangles([Index])
Refresh()
Resize
RightAngleAxes [= setting]
Rotation [= setting]
SaveAs(Filename, [FileFormat], [Password], [WriteResPassword], [ReadOnlyRecommended], [CreateBackup], [AddToMru], [TextCodepage], [TextVisualLayout], [Local])
Scripts
ScrollBars([Index])
Select([Replace])
SeriesChange
SeriesCollection([Index])
SetBackgroundPicture(Filename)
SetSourceData(Source, [PlotBy])
Shapes
ShowWindow [= setting]
SizeWithWindow [= setting]
Spinners([Index])
SubType [= setting]
SurfaceGroup
Tab
TextBoxes([Index])
ToString()
Type [= setting]
Unprotect([Password])
Visible [= setting]
Walls
WallsAndGridlines2D [= setting]
XYGroups([Index])

ChartArea (1995) Represents the chart area of a chart. The chart area on a 2-D chart contains the axes, the chart title, the axis titles, and the legend. The chart area on a 3-D chart contains the chart title and the legend; it doesnt include the plot area (the area within the chart area where the data is plotted). For information about formatting the plot area, see the PlotArea object.

Application
AutoScaleFont [= setting]
Border
Clear()
ClearContents()
ClearFormats()
Copy()
Creator
Fill
Font
Height [= setting]
Interior
Left [= setting]
Name
Parent
Select()
Shadow [= setting]
Top [= setting]
Width [= setting]

ChartEvents (1997) Hidden or unsupported element.

Activate()
BeforeDoubleClick(ElementID, Arg1, Arg2, Cancel)
BeforeRightClick(Cancel)
Calculate()
Deactivate()
DragOver()
DragPlot()
MouseDown(Button, Shift, x, y)
MouseMove(Button, Shift, x, y)
MouseUp(Button, Shift, x, y)
Resize()
Select(ElementID, Arg1, Arg2)
SeriesChange(SeriesIndex, PointIndex)

ChartGroup (1995) Represents one or more series plotted in a chart with the same format. A chart contains one or more chart groups, each chart group contains one or more ChartGroups collection.

Application
AxisGroup [= setting]
BubbleScale [= setting]
Creator
DoughnutHoleSize [= setting]
DownBars
DropLines
FirstSliceAngle [= setting]
GapWidth [= setting]
Has3DShading [= setting]
HasDropLines [= setting]
HasHiLoLines [= setting]
HasRadarAxisLabels [= setting]
HasSeriesLines [= setting]
HasUpDownBars [= setting]
HiLoLines
Index
Overlap [= setting]
Parent
RadarAxisLabels
SecondPlotSize [= setting]
SeriesCollection([Index])
SeriesLines
ShowNegativeBubbles [= setting]
SizeRepresents [= setting]
SplitType [= setting]
SplitValue [= setting]
SubType [= setting]
Type [= setting]
UpBars
VaryByCategories [= setting]

ChartGroups (1995) A collection of all the ChartGroup objects in the specified chart. Each ChartGroup object represents one or more series plotted in a chart with the same format. A chart contains one or more chart groups, each chart group contains one or more series, and each series contains one or more points. For example, a single chart might contain both a line chart group, containing all the series plotted with the line chart format, and a bar chart group, containing all the series plotted with the bar chart format.

Application
Count
Creator
GetEnumerator()
Item(Index)
Parent

ChartObject (1995) Represents an embedded chart on a worksheet. The ChartObject object acts as a container for a ChartObjects collection. The ChartObjects collection contains all the embedded charts on a single sheet.

Activate()
Application
Border
BottomRightCell
BringToFront()
Chart
Copy()
CopyPicture([Appearance], [Format])
Creator
Cut()
Delete()
Duplicate()
Enabled [= setting]
Height [= setting]
Index
Interior
Left [= setting]
Locked [= setting]
Name [= setting]
OnAction [= setting]
Parent
Placement [= setting]
PrintObject [= setting]
ProtectChartObject [= setting]
RoundedCorners [= setting]
Select([Replace])
SendToBack()
Shadow [= setting]
ShapeRange
Top [= setting]
TopLeftCell
Visible [= setting]
Width [= setting]
ZOrder

ChartObjects (1995) A collection of all the Chart object. Properties and methods for the ChartObject object control the appearance and size of the embedded chart on the sheet.

Add(Left, Top, Width, Height)
Application
Border
BringToFront()
Copy()
CopyPicture([Appearance], [Format])
Count
Creator
Cut()
Delete()
Duplicate()
Enabled [= setting]
GetEnumerator()
Group()
Height [= setting]
Interior
Item(Index)
Left [= setting]
Locked [= setting]
OnAction [= setting]
Parent
Placement [= setting]
PrintObject [= setting]
RoundedCorners [= setting]
Select([Replace])
SendToBack()
Shadow [= setting]
ShapeRange
Top [= setting]
Visible [= setting]
Width [= setting]

Charts (1995) A collection of all the chart sheets in the specified or active workbook. Each chart sheet is represented by a Chart object. This doesnt include charts embedded on worksheets or dialog sheets. For information about embedded charts, see the ChartObject object.

Add([Before], [After], [Count])
Application
Copy([Before], [After])
Count
Creator
Delete()
GetEnumerator()
HPageBreaks
Item
Move([Before], [After])
Parent
PrintOut([From], [To], [Copies], [Preview], [ActivePrinter], [PrintToFile], [Collate], [PrToFileName])
PrintPreview([EnableChanges])
Select([Replace])
Visible [= setting]
VPageBreaks

ChartTitle (1995) Represents the chart title.

Application
AutoScaleFont [= setting]
Border
Caption [= setting]
Characters
Creator
Delete()
Fill
Font
HorizontalAlignment [= setting]
Interior
Left [= setting]
Name
Orientation [= setting]
Parent
ReadingOrder [= setting]
Select()
Shadow [= setting]
Text [= setting]
Top [= setting]
VerticalAlignment [= setting]

DisplayUnitLabel (2000) Represents a unit label on an axis in the specified chart. Unit labels are useful for charting large valuesfor example, in the millions or billions. You can make the chart more readable by using a single unit label instead of large numbers at each tick mark.

Application
AutoScaleFont [= setting]
Border
Caption [= setting]
Characters
Creator
Delete()
Fill
Font
HorizontalAlignment [= setting]
Interior
Left [= setting]
Name
Orientation [= setting]
Parent
ReadingOrder [= setting]
Select()
Shadow [= setting]
Text [= setting]
Top [= setting]
VerticalAlignment [= setting]

Series (1995) Represents a series in a chart. The Series object is a member of the SeriesCollection collection.

Application
ApplyCustomType(ChartType)
ApplyDataLabels([Type], [LegendKey], [AutoText], [HasLeaderLines], [ShowSeriesName], [ShowCategoryName], [ShowValue], [ShowPercentage], [ShowBubbleSize], [Separator])
ApplyPictToEnd [= setting]
ApplyPictToFront [= setting]
ApplyPictToSides [= setting]
AxisGroup [= setting]
BarShape [= setting]
Border
BubbleSizes [= setting]
ChartType [= setting]
ClearFormats()
Copy()
Creator
DataLabels([Index])
Delete()
ErrorBar(Direction, Include, Type, [Amount], [MinusValues])
ErrorBars
Explosion [= setting]
Fill
Formula [= setting]
FormulaLocal [= setting]
FormulaR1C1 [= setting]
FormulaR1C1Local [= setting]
Has3DEffect [= setting]
HasDataLabels [= setting]
HasErrorBars [= setting]
HasLeaderLines [= setting]
Interior
InvertIfNegative [= setting]
LeaderLines
MarkerBackgroundColor [= setting]
MarkerBackgroundColorIndex [= setting]
MarkerForegroundColor [= setting]
MarkerForegroundColorIndex [= setting]
MarkerSize [= setting]
MarkerStyle [= setting]
Name [= setting]
Parent
Paste()
PictureType [= setting]
PictureUnit [= setting]
PlotOrder [= setting]
Points([Index])
Select()
Shadow [= setting]
Smooth [= setting]
Trendlines([Index])
Type [= setting]
Values [= setting]
XValues [= setting]

SeriesCollection (1995) A collection of all the Series objects in the specified chart or chart group.

Add(Source, [Rowcol], [SeriesLabels], [CategoryLabels], [Replace])
Application
Count
Creator
Extend(Source, [Rowcol], [CategoryLabels])
GetEnumerator()
Item(Index)
NewSeries()
Parent
Paste([Rowcol], [SeriesLabels], [CategoryLabels], [Replace], [NewSeries])

SeriesLines (1995) Represents series lines in a chart group. Series lines connect the data values from each series. Only 2-D stacked bar or column chart groups can have series lines. This object isnt a collection. Theres no object that represents a single series line; you either have series lines turned on for all points in a chart group or you have them turned off.

Application
Border
Creator
Delete()
Name
Parent
Select()