Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Labels Overrun Each Other
Hi...I've got an XY Scatter plot. I used VBA code from John Walkenbach
(J-Walk) to add specific descriptive text to each plotted point rather than the value of the point that is the (useless) default in Excel. A number of my points are clustered close together, so the descriptive texts run on top of each other making them illegible. Has anybody written VBA code to automatically reposition labels so they are all legible? This would require calculating the distance from one point to its neighbors and moving the data labels if the points are too close together. If there is a cluster of three points, one label may have to move up, another stay put and the third move down. This sounds like an interesting (and difficult) math challenge. Moving the labels manually on a lot of charts is a real pain in the neck. TIA! Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How select all data points/data labels at once (to format)? | Charts and Charting in Excel | |||
Possible Macro Timing Overrun generates Excel Exception | Excel Discussion (Misc queries) | |||
Setting hover data labels to cells other than source data | Charts and Charting in Excel | |||
Setting hover data labels to cells other than source data | Excel Discussion (Misc queries) | |||
renaming data labels by different cells than source data | Charts and Charting in Excel |