ChartArea.Clear Method (Excel)
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.
Charts("Chart1").ChartArea.Clear