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/

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/
>

[mansfield444]

Great recommendation on the app. Just downloaded it and it's doing exactly what I need. Many thanks!