I would like to be able to plot the pieces of info for each data point in a
scatter plot and have all the information appear when the mouse hovers above
each point, i.e.: Name of School, percentage of test takers, percentage
passed. Is this possible?

Hello, Marie!
You wrote on Tue, 3 Oct 2006 08:08:02 -0700:

M I would like to be able to plot the pieces of info for each
M data point in a scatter plot and have all the information
M appear when the mouse hovers above each point, i.e.: Name of
M School, percentage of test takers, percentage passed. Is
M this possible?

I'll admit I don't know how to do this but is a scatter plot
appropriate anyway? This is a little unusual since much more
often people try to plot scatter data in a line plot :-)

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not

I am interested in the response to this. I am trying to plot map points onto
a graphic using different symbols, and the abilty to pop-up more info would
be welcome.


"James Silverton" wrote in message
...
Hello, Marie!
You wrote on Tue, 3 Oct 2006 08:08:02 -0700:

M I would like to be able to plot the pieces of info for each
M data point in a scatter plot and have all the information
M appear when the mouse hovers above each point, i.e.: Name of
M School, percentage of test takers, percentage passed. Is
M this possible?

I'll admit I don't know how to do this but is a scatter plot appropriate
anyway? This is a little unusual since much more often people try to plot
scatter data in a line plot :-)

James Silverton
Potomac, Maryland

E-mail, with obvious alterations: not.jim.silverton.at.comcast.not

More often than not, people use a line chart, because they think it's the
only way to connect points with a line. But they get unexpected results
because they needed both X and Y value axes to portray their data, which an
XY chart provides, while a Line chart treats X values as categorical data.

http://pubs.logicalexpressions.com/P...cle.asp?ID=190
http://peltiertech.com/Excel/ChartsH...ValueAxis.html

I surmise from her description that Marie has selected an appropriate chart
type for her requirements.

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


"James Silverton" wrote in message
...
Hello, Marie!
You wrote on Tue, 3 Oct 2006 08:08:02 -0700:

M I would like to be able to plot the pieces of info for each
M data point in a scatter plot and have all the information
M appear when the mouse hovers above each point, i.e.: Name of
M School, percentage of test takers, percentage passed. Is
M this possible?

I'll admit I don't know how to do this but is a scatter plot appropriate
anyway? This is a little unusual since much more often people try to plot
scatter data in a line plot :-)

James Silverton
Potomac, Maryland

E-mail, with obvious alterations: not.jim.silverton.at.comcast.not

Marie -

Excel doesn't have this capability built-in, but it is flexible enough that
clever programmers can provide similar functionality. In this case, the
clever programmer is my colleague Tushar Mehta. On his web site
(http://tushar-mehta.com) is a utility called Chart Hover Labels, which will
do what you need.

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


"Marie" wrote in message
...
I would like to be able to plot the pieces of info for each data point in a
scatter plot and have all the information appear when the mouse hovers
above
each point, i.e.: Name of School, percentage of test takers, percentage
passed. Is this possible?

Thank you, Thank you, Thank you! It worked perfectly. The only thing left is
to figure out how to spread out the points a bit so that the names do not
cluster together (making them illegible). However, I believe I just need to
make the x-axis number range smaller (instead of a range between 0-20, I will
make it 0-5, 6-10, ect)...is this correct?

-Marie

"Jon Peltier" wrote:

Marie -

Excel doesn't have this capability built-in, but it is flexible enough that
clever programmers can provide similar functionality. In this case, the
clever programmer is my colleague Tushar Mehta. On his web site
(http://tushar-mehta.com) is a utility called Chart Hover Labels, which will
do what you need.

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


"Marie" wrote in message
...
I would like to be able to plot the pieces of info for each data point in a
scatter plot and have all the information appear when the mouse hovers
above
each point, i.e.: Name of School, percentage of test takers, percentage
passed. Is this possible?

MArie,
Not sure if this will get to you since it has been nearly 2 years but I will
ask anyway. You indicte you got this add-in to work. But I am running Excel
2002 and can not get it to work. Keep getting run-time error 91 which
translate to not referencing a valid variable. What version of Excel were you
using?

"Marie" wrote:

Thank you, Thank you, Thank you! It worked perfectly. The only thing left is
to figure out how to spread out the points a bit so that the names do not
cluster together (making them illegible). However, I believe I just need to
make the x-axis number range smaller (instead of a range between 0-20, I will
make it 0-5, 6-10, ect)...is this correct?

-Marie

"Jon Peltier" wrote:

Marie -

Excel doesn't have this capability built-in, but it is flexible enough that
clever programmers can provide similar functionality. In this case, the
clever programmer is my colleague Tushar Mehta. On his web site
(http://tushar-mehta.com) is a utility called Chart Hover Labels, which will
do what you need.

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


"Marie" wrote in message
...
I would like to be able to plot the pieces of info for each data point in a
scatter plot and have all the information appear when the mouse hovers
above
each point, i.e.: Name of School, percentage of test takers, percentage
passed. Is this possible?