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