Software > Excel

Attaching data labels in an XY scatter plot

There's no obvious way to label individual points in an XY plot but it actually can be done. Here's how.
By hand
A good general explanation (not specific to XY plots) is available here.  The instructions also apply to XY plots with one modification.  In an XY plot, there's no "Value" box to check on the "Data Labels" dialog.  Instead, it offers "Series Name", "X Value" and "Y Value".  Click any one of the three and then follow the remaining instructions.
Via a macro
The official Microsoft explanation is available here.
Site Index | Zoom | Admin
URL: https://wilcoxen.maxwell.insightworks.com/pages/1973.html
Peter J Wilcoxen, The Maxwell School, Syracuse University
Revised 08/23/2006