Organize chart labels automatically

[mbobro]

Hi,

I have a chart that has 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

 

[Rita Palazzi]

You should be able to right-click on one of the series labels and change the
positioning so that it doesn't line up with those of the other series.
Right-Click, Format Data Labels, then on the "Alignment" tab, choose different
label positions and see if any of these work for you...

Hope this helps!
Rita