ChartSpace object: Deletes every chart in the chart workspace and resets all the formatting to the default values. Deletes every data source in the WCDataSources collection.
Range object: Deletes all formatting and data from the specified range.
Syntax
expression.Clear
expression An expression that returns a ChartSpace or Range object.