View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default Help with datapoints stack in XYScatter

There is no built-in way that will prevent overlap of data labels. I've seen
a crude attempt that uses vba to move data labels out of each other's way,
but I don't think the author has developed it further. It's a lot of work.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

"PO" <h wrote in message ...
hello,

Is there any way (using chart settings or VBA) to prevent the datalabels
to stack (ontop of each other) in a XYScatter chart when the xValues and
values of several datapoints coincide?

Regards
PO