Organize chart labels automatically

[mbobro]

Hi,

I have a hundreds of similar charts that have 3 series:
- one is a column
- second is Scattered plot
- third is also scatter plot, but is used only to make a horizonta
line on the whole chart

I have also data labels for them that. unfortunately. sometimes ar
placed one on another that you can't read it.

Of course I may organize it manually, but this is very, very tim
consuming. Is there any way to do it automatically, or best of all
thorugh VBA?

thanks,


Micha