Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Identifying Scatter Plot Points.
by Allen Wyatt
(last updated August 15, 2015)
Phil asked if it was possible to control exactly what information is shown as data labels in a scatter plot (xy) graph. It seems such functionality is not built directly into Excel. The best solutions involve the use of third-party add-ins to produce the desired results.
One highly recommended add-in is the XY Chart Labeler, created by Rob Bovey. You can find this free add-in here:
You can also find xy chart labeling features in some commercial add-ins, such as the Power Utility Pak by John Walkenbach:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2615) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Identifying Scatter Plot Points.
Professional Development Guidance! Four world-class developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors show how to consistently make the right design decisions and make the most of Excel's powerful features. Check out Professional Excel Development today!
When you create a chart, Excel often includes a legend with the chart. You can format several attributes of the legend's ...Discover More
Once you create a chart, you aren't limited to keeping the data series in the order they originally appeared. You can shift ...Discover More
You spent a lot of time getting your chart to look just the way you wanted. Now you want to create a graphic file from that ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."