Removing a serie in a chart

R

Renaud

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


Code:
--------------------
While Charts("Chart1").SeriesCollection.Count > 0
Charts("Chart1").SeriesCollection.Item(1).Delete
Wend
--------------------


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

Renaud
 

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

Macro to Select text from a point given to a specific word 2
Chart SERIES OFFSET 5
Chart x-axis and name problem 1
Excel 2007 pivot chart/table copying vs Excel 2003 0
Store Current Selection As Range Variable. 3
Odd Chart Format Results 1
BringToFront syntax question 2
Word macro that can call cells out of Excel for a find and replace 0

Top