Data Labels as Chart Points?

imported_Anonymous · May 14th 2003

Is there a way to make the chart point into a letter e.g. if I want to plot (23, 44) for person AD and (27,48) for person BF on a chart and have the points come up as AD and BF on the chartr instead of dots etc?

Thanks, [email protected]

Egad · May 14th 2003

1) Create your chart showing points
2) right click on one of the points to show the Format Data Series option
3) under the Data Labels Tab - choose "show label'
4) under the Patterns Tab - choose 'Line-none' and 'Marker-none'

Anonymous · May 14th 2003

As Egad suggests, but also center the labels. See the attached example (Egad respoinded while I was building the example, but rather than discarding it, I'll post it).

**Andy Pope** · May 14th 2003

Hi Guys,

If the chart is an xy scatter then displaying data labels will only result in either the X or the Y value being displayed.

In order to link the data labels with extra text you could use either of these free addins.

Rob Bovey's XY Chart Labeler:
http://www.appspro.com/utilities/utilities.asp

JWalk Chart Tools:
http://j-walk.com/ss/excel/files/charttools.htm

Cheers
Andy

Data Labels as Chart Points?

Participate now!

Share