View Single Post
  #3   Report Post  
John Mansfield
 
Posts: n/a
Default

Mike,

The technique described at the site below uses a VBA worksheet calculate
event to automate the updating of XY chart labels. The example can be
downloaded fom the site as well.

http://www.pdbook.com/index.php/exce...t_data_labels/

----
Regards,
John Mansfield
http://www.pdbook.com

"Mike K." wrote:

Sorry if this is a repeated request, but I'm trying to show the distribution
of 16 points (labelled A through P) using X-Y coordinates. When I turn on
labels, I can show either the X-positions (label) or Y-positions (value), but
I really want to show the text name "A" through "P". Can this be automated
in Excel?
Thanks for any advice.