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

controlling chart location 1
SeriesCollection(2).Formula returns formula for series 1 1
SeriesCollection.(X)Values: locale settings specific? 4
Need help with SeriesCollection Object Please ! 10
Chart DataLabel Placement Error 2
Chart Identification Problems 2
Problem with creating chart within existing worksheet. 1
Very wierd problem. Please help 1

Top