Organize chart labels automatically

  • Thread starter Thread starter mbobro
  • Start date Start date
M

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
 
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
 
Back
Top