View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default show 3 sets of data per data point in a scatter plot

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