I tried to separate the boxes and the lines without result. The i is corrupt!
I see the problem but i don't know how to solve it.
Box 1 to 7 has to trigger ActiveChart.SeriesCollection(i).Format.Line 1 to 7 of grafiek 1
Box 7 to 14 has to trigger ActiveChart.SeriesCollection(i).Format.Line 1 to 7 of grafiek 2
But i don't know how to change the second macro to setup the boxes like that.
I really like the feature because i can see witch line (flow) is causes the problem. Then i can disable the other lines and make a other chart visible to see what is causing the flow drop.
Bookmarks