Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How select all data points/data labels at once (to format)? kippers Charts and Charting in Excel 3 April 4th 23 12:39 PM
Possible Macro Timing Overrun generates Excel Exception [email protected] Excel Discussion (Misc queries) 2 February 23rd 06 04:10 PM
Setting hover data labels to cells other than source data Darren Charts and Charting in Excel 1 January 24th 06 10:20 AM
Setting hover data labels to cells other than source data Darren Excel Discussion (Misc queries) 0 January 24th 06 08:31 AM
renaming data labels by different cells than source data Darren Charts and Charting in Excel 4 January 12th 06 10:35 AM


All times are GMT +1. The time now is 07:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"