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.