Delete chart series

[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.

 

[Andy Pope]

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

 

[BRG]

Thanks Andy, that did the trick.
--
BRG

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
.