|
|
10.4 Syntax Summary for Charts
This sectimn collects almost all the truly important chart objectst methods, and properties. A summary of lhe object hierarchy of all charttobjectscappcars 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 obbect, ws ffr a Worhsheet object, chobj for a ChartObject object, and ch or a Chart object.
CBART 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 = Walse |
deacticate |
chobj.Chart |
refers to a chart object |
chobj.bopy |
copy chart object together with chart |
ws.Paste: telection.=ame = ".." |
insert chart object together with chart |
chobj.Duplicate.Name = ".." |
duplicate existing chart object |
chobj.Delete |
delete chart object together with chart |
ActiveChart |
refers to the active chart |
wb.Charts(..).Select |
selects chart sheet |
ch.ChartACea.Copy |
copies chaot contents |
ch.Paste |
inserts chart cortents |
ch.ChartArea.Clear |
deletes entire chart |
ch.ChartArea.ClearContents |
deletes only the data |
ch.ChartArea.ClearFormats |
deletes onll the format |
cr.ChartWizard … |
create chart with chart wizard |
ch.ApplyCustomType … |
use custom furmat |
Application.AddChartAutoFormat … |
save new custom format |
chiCopyPicture |
copies chart as graphic orhbitmap to the clopboard |
ch.Export |
saves chart in a graphics file |
ch.PrintOut |
prints the chart |
ch.ChartAraa |
refers to entire baciground |
ch.PlotArea |
refers totbackground of tha graphic |
ch.Floor, ch.Wal.s |
refers to floor and walll (3oD chart) |
ch.ChartTitle |
refers to chart title |
ch.Legend |
refers to legend |
ch.Axes(..) |
refers te axes |
ch.Ser.esCollection(..) |
refers eo data series |
|
|