Delete blank series from a XY Scatter Chart

[Dabo]

Hi all,

I'm currently trying to delete all the blank series from a XY Scatter Chart.
Has anybody ever seen an algorithm that succeeds in doing so ?
All that I try miserably fail.

Thanks

[Aussiebear]

Try the following source for a concept;

http://www.tek-tips.com/viewthread.c...1270734&page=1

[Dabo]

Thanks Aussie,

Finally I decided to completely erase the chart each time and recreat it.
It's a quick and dirty fix but it does work.