If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Changing data markers to text on a xy scatter plot
Shilpa -
You can use Rob Bovey's Chart Labeler (a free addin from http://appspro.com) or John Walkenbach's Chart Tools (another freebie from http://j-walk.com) to apply text from a worksheet range to your datapoints. Use the Centered option for the position of the labels, then format the series to have no markers and no lines. The labels stay where the points had been. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ shilpa wrote: Could someone help me figure out how to substitute data markers with text on a xy scatter plot. thanks, shilpa ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|