Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 Last edited by Renaud : May 31st 05 at 02:51 PM |
#2
![]() |
|||
|
|||
![]()
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 Renaud |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Removing "0"s from a chart | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
Removing specific data from a bar chart | Charts and Charting in Excel |