Scatter graph with text as marker ?

  • Thread starter Thread starter Dag Fjeld Edvardsen
  • Start date Start date
D

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
 
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
 
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
 
Back
Top