Create multiple charts on multiple sheets

[Carl11235]

Hi,
I need some help with understanding why my macro behaves like it does.

The macro creates multiple charts from data in one sheet, but now when I'm trying to scale it up to multiple sheets, the previous charts created disappear. E.g Creates 5 charts for sheet 1 (can see them being created, using debugger mode), looping to the next chart and they are created but the first ones has disappeared! What am I doing wrong? I'm creating my chart by the following code:

Please Login or Register  to view this content.

The startpoint variable is changed for every new chart within the one sheet and the outputsheet is changed when you change the sheet

Thanks in advance
Carl

[natefarm]

Would you be able to attach the workbook with sample data?

[Carl11235]

Ok, here is my document..

The 14 first sheets contain data from a simulation program (labeled: exp ...), which we change to a better format and trying to enter a chart for every train or station (we are simulating train departures). At the moment we only get charts for the last 2 out of 14 formated sheets (the 2 last, Esbjerg Niebull Train and Station). The remaining charts are deleted somehow when charts are created on the next sheet (able to see it from debug mode). The charts are created in sub writeDataStation and writeDataTrain, at the bottom.

I know you were looking for a sample, but the sample code attached in my first post, so I post the whole thing.

If you can't find the answer I can do it a more time consuming way

Thanks in advance
Carl

[natefarm]

In your "main" subroutine, you are looping through your 7 pairs of Train/Station sheets. The "clearsheets" deletes all charts in all sheets every time, leaving only the last pair uncleared when you're done.

[Carl11235]

Thank you Forgot that one