Updating data point names

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jerry - 02 Sep 2004 17:30 GMT

I am currently creating scatter plot charts, but in the
abscence of data labels on the chart I am unable to
distinguish which data point relates to what data.

I was hoping not to have to actually insert the data
point names on the chart, but to have the Data Point name
update so that when you hover with the mouse over the
point it comes up with a meaningful name for the data
point.

Any ideas?

Reply to this Message

Jon Peltier - 02 Sep 2004 22:57 GMT

Jerry -

Presumably the point names come from a worksheet range. There are
utilities freely available that can apply the labels from a worksheet
range to the points in a chart. Two good ones are Rob Bovey's Chart
Labeler (http://appspro.com) and John Walkenbach's Chart Tools
(http://j-walk.com). These are free, easy to install, and easy to use.

These are permanent labels, not the chart tips you see when the mouse
hovers over a point. If you want the names only to appear when you mouse
over a point, try the Chart Hover Label utility on Tushar Mehta's web
site (http://tushar-mehta.com).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

> I am currently creating scatter plot charts, but in the
> abscence of data labels on the chart I am unable to
[quoted text clipped - 7 lines]
>
> Any ideas?

Reply to this Message

Jerry - 03 Sep 2004 11:58 GMT

Jon

Many thanks!

Jerry

>-----Original Message-----
>Jerry -
[quoted text clipped - 31 lines]
>
>.

Reply to this Message