ChartArea.ClearContents Method (Excel)
Clears the data from a chart but leaves the formatting.
Syntax
expression .ClearContents
expression A variable that represents a ChartArea object.
Return Value
Variant
Example
This example clears the chart data from Chart1 but leaves the formatting intact.
Charts("Chart1").ChartArea.ClearContents