Clear Method
Applies To
ChartArea object, Legend object, Range object.
Description
Clears the entire range or chart area.
Syntax
expression.Clear
expression Required. An expression that returns a ChartArea or Range object.
See Also
ClearContents method, ClearFormats method.
Example
This example clears the formulas and formatting in cells A1:G37 on the datasheet.
myChart.Application.DataSheet.Range("A1:G37").Clear
This example clears the chart area (the chart data and formatting) of myChart.
myChart.ChartArea.Clear