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