Share via


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

See Also

Concepts

ChartArea Object

ChartArea Object Members