Updating data point names

  • Thread starter Thread starter Jerry
  • Start date Start date
J

Jerry

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?
 
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/
_______
 
Jon

Many thanks!

Jerry
-----Original Message-----
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/
_______


.
Click to expand...
 
Back
Top