Removing a serie in a chart (VBA)
 

Hello,

I'm trying to make a vba script that replaces the series in a graph by other series. The problem is that I cannot find a method to remove a serie from a seriescollection (I find a method to add a new one, but not to remove an old one). The add method had an argument that allows the replacement of serie by the new one, but the number of series varies, so I cannot use it.

I also saw that the object series responds to the 'Delete' method, but I did not find how to use it.

Thanks in advance,

Renaud

I'm answering to myself. I finally found. Here is the solution:

But if you've better ideas, i'm taker.

Renaud