can't delete a series from SeriesCollection ???

K

keith

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
 
J

joel

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
 
K

keith

Hi Joel,
Thank you.
Keith

joel said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 chart question 0
Can't seem to delete all images from a Word Doc 2
controlling chart location 1
Putting the series 1 and series 2 titles from a worksheet 0
SeriesCollection(2).Formula returns formula for series 1 1
How to Expose SeriesCollection? 0
Need help with SeriesCollection Object Please ! 10
How many series does this code create??? 0

Top