 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / November 2003Scatter graph with text as marker ?
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).  SignatureRegards, Tushar Mehta, MS MVP -- Excel www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions > How do I replace the data point markers (diamond, star etc.) with > text which is unique for each data point? [quoted text clipped - 10 lines] > > - Dag Thank you. The add-in you suggested works perfectly! - Dag You are welcome. Glad to be of help. SignatureRegards, Tushar Mehta, MS MVP -- Excel www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions > Thank you. > > The add-in you suggested works perfectly! > > - Dag |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.