Excel Scatter Chart with Labels

You could use this addon http://www.appspro.com/Utilities/ChartLabeler.htm

There's another free utility (and tutorial on how to create it) available for download here: http://www.wiseowl.co.uk/blog/s130/excel-charts-data-labels-problem.htm

At first, I thought you could accomplish this with a 'bait and switch' - make a plot of the data first, then edit the series. Doesn't work though. This works if and only if the numbers in column 'B' are whole numbers. The excel chart isn't really using any of the data in column B anymore.

The only way I have been able to reliably do this in the past is to make every row of data it's own data series. Painful, but if you want to see it in action, I have an example excel file.

The wiseowl.co.uk utility worked for me. As a "tutorial" I would recommend

1. Downloading this Excel worksheet, from part five of this blog and enabling macros http://www.wiseowl.co.uk/files/blogs/s130/i3.xlsm

2. Move the button down and out of the way of your data if you have more than a few columns

3. Paste your data in on top of the film data.

4. Create scatter plots by selecting two column at a time and insert scatter (plot).

5. Clicking on the button, which will add labels.

Easy.

Thanks to the folks that made it and recommended it.