| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete chart series
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. -- BRG |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete chart series
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 wrote: 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, Microsoft MVP - Excel http://www.andypope.info |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete chart series
Thanks Andy, that did the trick.
-- BRG "Andy Pope" wrote: 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 wrote: 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, Microsoft MVP - Excel http://www.andypope.info . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User Selectable Series and Number of Series for Line Chart | Charts and Charting in Excel | |||
| Delete Empty Series from Chart | Excel Programming | |||
| Chart series delete all then add new | Excel Programming | |||
| Chart, Series delete event | Charts and Charting in Excel | |||
| Chart, series delete event over context menue | Charts and Charting in Excel | |||
Linear Mode
