xy scatter charts

TBlack · 07-31-2006, 07:08 PM

I have created a scatter chart with a large data set. Instead of seeing
each label in the chart, I want to be able to hover over a specif point
and it give me the label pertaining to the point. I am plotting by
product the volume (x axis) and price (y axis). There are too many
product codes to have the label show up on the chart.

--
TBlack
Posted from - http://www.officehelp.in

Jon Peltier · 08-01-2006, 12:08 AM

If the chart tip isn't what you want, you can make Excel show a custom
label, using Tushar Mehta's Chart Hover Label utility, at
http://tushar-mehta.com

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

"TBlack" <[email protected]> wrote in message
news:[email protected]...
>
> I have created a scatter chart with a large data set. Instead of seeing
> each label in the chart, I want to be able to hover over a specif point
> and it give me the label pertaining to the point. I am plotting by
> product the volume (x axis) and price (y axis). There are too many
> product codes to have the label show up on the chart.
>
>
> --
> TBlack
> Posted from - http://www.officehelp.in
>

**Zer0** · 11-24-2012, 02:03 PM

This may be stale seeing that my response is 6 years later but FYI only I've managed to by pure accident to achieve a very very similar solution to Tusha Mehtar's Hover Label tool.

First it involves setting the labels using Rob Bovey's very handy (and free ! how crazy is that ?!) XYChartLabeller <http://www.appspro.com/Utilities/ChartLabeler.htm>

After which you stick this piece of code in the private module of the relevant chart you want this to work on

Please Login or Register  to view this content.

**arlu1201** · 11-25-2012, 01:36 AM

Zer0,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.