Delete chart series

  • Thread starter Thread starter BRG
  • Start date Start date
B

BRG

I am having a problem deleting a chart series. The series contains a zero
value. The chart is a log-log plot. I am using the following code to try
and delete the series.

Activesheet.Seriescollection().Delete

I get the error:

Delete method of Series class failed.

The code works if there are no zero values in the series. Any help would be
greatly appreciated.
 
Hi,

Sometimes it helps to change the chart type of the series to a column
chart before deleting the series.

Application.DisplayAlerts = False
With ActiveChart.SeriesCollection(1)
.ChartType = 51
.Delete
End With
Application.DisplayAlerts = True

If the chart only has 1 series you will need to set the chart type back
to original type when adding new series.

Cheers
Andy
 
Thanks Andy, that did the trick.
--
BRG


Andy Pope said:
Hi,

Sometimes it helps to change the chart type of the series to a column
chart before deleting the series.

Application.DisplayAlerts = False
With ActiveChart.SeriesCollection(1)
.ChartType = 51
.Delete
End With
Application.DisplayAlerts = True

If the chart only has 1 series you will need to set the chart type back
to original type when adding new series.

Cheers
Andy


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
.
Click to expand...
 
Back
Top