chart default series

[Leo_Fouhy]

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.

[Andy Pope]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Please use code tags, even for small chunks of code.

If the active cell is in a area of data excel will attempt to use the current region as data source.

Either make sure the active cell is away from all data or use the code posted to remove unwanted data series.