I'm creating a number of different graphs for analysis of data.
If I create a new graph through the menu system I get a blank graph with no series data as expected. If I create a new graph with VBA "ActiveSheet.Shapes.AddChart.Select" the computer hangs for a minute or two then produces a new chart with several series already in it based on large areas of the spreadsheet.
How can I stop this from happening??
I'm using
Do Until .SeriesCollection.Count = 0
.SeriesCollection(1).Delete
Loop
To clear the problem but I would like excel to stop producing the problem to start with.
Bookmarks