ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Help with datapoints stack in XYScatter (https://www.excelbanter.com/charts-charting-excel/88566-help-datapoints-stack-xyscatter.html)

PO

Help with datapoints stack in XYScatter
 
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



Jon Peltier

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





All times are GMT +1. The time now is 11:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com