Clear Method
Clear method as it applies to the ChartArea and Legend objects.
Clears the entire chart area.
expression.Clear
*expression * Required. An expression that returns one of the above objects.
Clear method as it applies to the Range object.
Clears the entire range.
expression.Clear
*expression * Required. An expression that returns one of the above objects.
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 Chart1.
myChart.ChartArea.Clear
Applies to | ChartArea Object | Legend Object | Range Object
See Also | ClearContents Method | ClearFormats Method