ChartArea.ClearContents Method

Excel Developer Reference

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.

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

See Also