| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can't delete a series from SeriesCollection ???
Hello,
I see that SeriesCollection has a method ".NewSeries" that creates a new series as in... Charts(1).SeriesCollection.NewSeries But I don't see a way to delete a series, or delete all in the collection. What am I missing here? Thank you, Keith |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
can't delete a series from SeriesCollection ???
when I can't find the documention for an instruction I do the simple thing.
I record a macro and perform the operatiopn manually. Then use the record code. I generated a simple 3 series collection chart. then started the macro recorder and deleted a series. Here is what I got ActiveChart.SeriesCollection(3).Delete "keith" wrote: Hello, I see that SeriesCollection has a method ".NewSeries" that creates a new series as in... Charts(1).SeriesCollection.NewSeries But I don't see a way to delete a series, or delete all in the collection. What am I missing here? Thank you, Keith |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
can't delete a series from SeriesCollection ???
Hi Joel,
Thank you. Keith "joel" wrote: when I can't find the documention for an instruction I do the simple thing. I record a macro and perform the operatiopn manually. Then use the record code. I generated a simple 3 series collection chart. then started the macro recorder and deleted a series. Here is what I got ActiveChart.SeriesCollection(3).Delete "keith" wrote: Hello, I see that SeriesCollection has a method ".NewSeries" that creates a new series as in... Charts(1).SeriesCollection.NewSeries But I don't see a way to delete a series, or delete all in the collection. What am I missing here? Thank you, Keith |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SeriesCollection(2).Formula returns formula for series 1 | Excel Programming | |||
| Delete Empty Series from Chart | Excel Programming | |||
| Chart series delete all then add new | Excel Programming | |||
| delete series of letter in spreadsheet | Excel Worksheet Functions | |||
| Using SeriesCollection.Extend for a specific Chart Data Series | Excel Programming | |||
Linear Mode
