Hello everyone,

Here's the situation. I currently have a scatter plot where each point represents a different stock and how it's performing based on different metrics on the X & Y axis. When I refresh my data, the points move accordingly, however the labels for each point often get overlapped or too crowded in this process. As a result, I have been manually readjusting the labels each time for each point.

I am looking for a way to make the point labels "spatially aware" so that that will auto adjust when they are on top of each other or too jumbled up to be legible. Additionally, the current point labels are often inconsistent in formatting. For example, some points will be closer to their labels than others or the label will change orientation around each of the points in many different ways (sometimes label will be diagonally above point, diagonally below point, left of point, etc.)

I believe the easiest way to approach this would be to make four options for labelling for consistency: left of point, right of point, centered above point, centered below point.

In terms of the overlapping / crowded point labels, I have been trying to figure out a VBA script to identify when labels intersect and correct them accordingly with small adjustments but haven't been having any luck. Looking for a clean, simple script to solve this issue. Automating this would save a significant portion of time so thank you in advance!