Scatter graph with text as marker ?

[Dag Fjeld Edvardsen]

How do I replace the data point markers (diamond, star etc.) with
text which is unique for each data point?

Example .. Lets say we have this dataset:

Name: Alfa Beta Gamma
X: 1 2 3
Y: 2 4 8

The goal is to replace the ordinary markers with
the word "Alfa" for the point (1,2), "Beta" for
the point (2,4) and so on... ?

- Dag

 

[Tushar Mehta]

How about adding the alfa, beta, etc. as data labels (use Rob Bovey's
XY Chartlabeler available from www.appspro.com). Center the labels and
set the marker to none (double-click the plotted series, then the
Patterns tab).

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Dag Fjeld Edvardsen]

Thank you.

The add-in you suggested works perfectly!

- Dag

 

[Tushar Mehta]

You are welcome. Glad to be of help.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions