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