ChartArea.Clear Method

Excel Developer Reference

Clears the entire object.

Syntax

expression.Clear

expression   A variable that represents a ChartArea object.

Return Value
Variant

Example
This example clears the chart area (the chart data and formatting) of Chart1.

Visual Basic for Applications
  Charts("Chart1").ChartArea.Clear

See Also