ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   how do I put a text label on a point in an XY scatter (https://www.excelbanter.com/charts-charting-excel/205054-how-do-i-put-text-label-point-xy-scatter.html)

Paul

how do I put a text label on a point in an XY scatter
 
I am a marketer and I use excel to plot 2 x 2 matricies using x y scatter
graphs but I cannot get the excel to put the text label on the datapoint

Jon Peltier

how do I put a text label on a point in an XY scatter
 
select the series, then select the point (two single clicks), then right
click and choose the format option. On the Data Label tab, add any default
label and click OK. Select this label (again, two single clicks), then click
the select the text in the label and type whatever you want.

If you have a lot of points, and the labels are in the worksheet, use one of
these free Excel utilities to add labels in bulk:

Rob Bovey's Chart Labeler, http://appspro.com/Utilities/ChartLabeler.htm
John Walkenbach's Chart Tools,
http://www.j-walk.com/ss/excel/files/charttools.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Paul" wrote in message
...
I am a marketer and I use excel to plot 2 x 2 matricies using x y scatter
graphs but I cannot get the excel to put the text label on the datapoint





All times are GMT +1. The time now is 02:43 AM.

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