Is there a way with code to clear the source data from an chart in Excel? I
don't want to delete the chart just clear the source data when the workbook
is closed.
Thanks

Hi John,

The following will remove each data series from the active chart.
Sub x()
' remove data from chart
With ActiveChart
Do While .SeriesCollection.Count 0
.SeriesCollection(1).Delete
Loop
End With
End Sub

Cheers
Andy


John wrote:
Is there a way with code to clear the source data from an chart in Excel? I
don't want to delete the chart just clear the source data when the workbook
is closed.
Thanks



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info