10.4 Syntax Summary for Charts

This section collects almost all the truly important chart objects, methods , and properties. A summary of the object hierarchy of all chart objects appears in Chapter 15. There, all objects are also briefly described. In the following syntax boxes we have used the following abbreviations: wb for a Workbook object, ws for a Worksheet object, chobj for a ChartObject object, and ch for a Chart object.

CHART OBJECTS
ws.ChartObjects(..)	select embedded chart object
ws.ChartObjects.Add ..	new (empty) chart frame
chobj.Select	corresponds to a single mouse click
chobj.Activate	corresponds to a single mouse click
ActiveWindow.Visible = False	deactivate
chobj.Chart	refers to a chart object

chobj.Copy	copy chart object together with chart
ws.Paste: Selection. Name = ".."	insert chart object together with chart
chobj.Duplicate.Name = ".."	duplicate existing chart object
chobj.Delete	delete chart object together with chart

CHARTS
ActiveChart	refers to the active chart
wb.Charts(..).Select	selects chart sheet
ch.ChartArea.Copy	copies chart contents
ch.Paste	inserts chart contents
ch.ChartArea.Clear	deletes entire chart
ch.ChartArea.ClearContents	deletes only the data
ch.ChartArea.ClearFormats	deletes only the format
ch.ChartWizard	create chart with chart wizard
ch.ApplyCustomType	use custom format
Application.AddChartAutoFormat	save new custom format

ch.CopyPicture	copies chart as graphic or bitmap to the clipboard
ch.Export	saves chart in a graphics file
ch.PrintOut	prints the chart
ch.ChartArea	refers to entire background
ch.PlotArea	refers to background of the graphic
ch.Floor, ch.Walls	refers to floor and walls (3-D chart)
ch.ChartTitle	refers to chart title
ch.Legend	refers to legend
ch.Axes(..)	refers to axes
ch.SeriesCollection(..)	refers to data series