Charts.Add, "sticky series" & work-around

I've build a workbook to run a simulation that creates two chart sheets. Each chart contains four data series generated by a function that calls the same chart creation function. I noticed that the second chart contained some but not all series from the first chart. So I ended up adding the following after the Charts.Add line:

Please Login or Register  to view this content.

There is probably a method that avoids needing this, but at least it works. Perhaps it applies elsewhere.

g

Thanks for the suggestion. Sounds like another instance of MS being more helpful than one might want.

I'm curious - how might you modify the code below to accomplish this. I tried variations on adding a cell select above the Charts.Add line and ended up with no series in the second chart.

Thanks, g

Please Login or Register  to view this content.

Will do. Thanks. g