ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Data point labels in XY scatter chart (https://www.excelbanter.com/charts-charting-excel/59489-data-point-labels-xy-scatter-chart.html)

TonyGB007

Data point labels in XY scatter chart
 
How can I label each data point in a XY or scatter chart ?

Example data

X Y Label
5 8 Fred
6 7 Bill
7 6 Jill

Thanks, Tony

Andy Pope

Data point labels in XY scatter chart
 
Hi,

You can link the data labels to the cells either manually
http://www.andypope.info/tips/tip001.htm

Or with the use of a addin. Here are a couple of examples.

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com/ss

Cheers
Andy

TonyGB007 wrote:
How can I label each data point in a XY or scatter chart ?

Example data

X Y Label
5 8 Fred
6 7 Bill
7 6 Jill

Thanks, Tony


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


All times are GMT +1. The time now is 01:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com