Automatic custom labels on Excel scatter plot

Keywords: Excel, custom labels, XY plot chart, scatter plot, macro

Version: Tested on Excel 2003 and Excel 2007

Download: Automatic scatter plot labels (downloaded 784 times)

Quite frequently there is a need to display custom lables in a standard Excel XY-plot. Unfortunately Excel lack a native function to insert custom labels; the only options available are Series names, x- and y-values which often are totally inappropriate. I created a workbook with a macro that allows the user to insert the X and Y data along with the desired lables and create a labled scatter plot with the click of a button. See image below.

All you have to do is to dowload the file, insert your labels and values and click the button! The chart may require some additional formatting to suit your needs. Enjoy!

Download: Automatic scatter plot labels (downloaded 784 times)

Popularity: 27% [?]