Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting shape series and trendlines
I'm trying to delete all 20 series and trendlines of a shape. My code
doesn't delete them. What is going wrong? ActiveSheet.ChartObjects("Shape 1").Activate For i = 1 To 20 Err.Clear ActiveChart.SeriesCollection(1).Delete Err.Clear Next i Thanks, Mika |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XL2003: Shape-borders on scatter-series' look wavy | Charts and Charting in Excel | |||
Format Shape, will not move accordingly, when deleting columns | Excel Discussion (Misc queries) | |||
How do I change the shape of a data series | Charts and Charting in Excel | |||
Deleting a shape and the cell contents the shape is in. | Excel Programming | |||
Deleting a shape and the cell contents the shape is in. | Excel Programming |