austin350s10
Active Member
- Joined
- Jul 30, 2010
- Messages
- 321
I am using VBA to remove all the series collections from a chart then add and reassign each series back in with a new set of data. The problem I am running into is that once I clear out all the series collections the chart looses all of its properties. Is there a way to retain the chart properties so they don't get lost?
I believe this is the line of code that is giving me problems:
I am using this code to loop through several charts. When the code finishes running all my charts have the same formatting as the first chart that is manipulated in the code.
I believe this is the line of code that is giving me problems:
Code:
With MyChart
For n = .SeriesCollection.Count To 1 Step -1
.SeriesCollection(n).Delete
Next n
End With
I am using this code to loop through several charts. When the code finishes running all my charts have the same formatting as the first chart that is manipulated in the code.
Last edited: