software

I'd like to make a dot plot that has multiple y axis values for a single
x axis value. For example, I'd like to have two locations on the x axis,
one labeled quot;girlsquot; and the other labeled quot;boysquot;. The y axis would be
height. Then above the quot;girlsquot; label, there would be one dot for each
girl in the room at the height of that girl and the same thing for the
boys. Is this possible in Excel?

Thanks.

Eric--
EJF
------------------------------------------------------------------------
EJF's Profile: www.excelforum.com/member.php...oamp;userid=32065
View this thread: www.excelforum.com/showthread...hreadid=525463Eric -

Use 0.25 for the left gender and 0.75 for the right, and plot this data as
an XY chart. Then hide the default axis labels and use this technique to add
custom X axis labels for quot;Girlsquot; and quot;Boysquot;:

peltiertech.com/Excel/Charts/ArbitraryAxis.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
peltiertech.com/Excel/ExcelUserConf06.html
_______

quot;EJFquot; gt; wrote in message
...
gt;
gt; I'd like to make a dot plot that has multiple y axis values for a single
gt; x axis value. For example, I'd like to have two locations on the x axis,
gt; one labeled quot;girlsquot; and the other labeled quot;boysquot;. The y axis would be
gt; height. Then above the quot;girlsquot; label, there would be one dot for each
gt; girl in the room at the height of that girl and the same thing for the
gt; boys. Is this possible in Excel?
gt;
gt; Thanks.
gt;
gt; Eric
gt;
gt;
gt; --
gt; EJF
gt; ------------------------------------------------------------------------
gt; EJF's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32065
gt; View this thread: www.excelforum.com/showthread...hreadid=525463
gt;

Thanks! That works well.--
EJF
------------------------------------------------------------------------
EJF's Profile: www.excelforum.com/member.php...oamp;userid=32065
View this thread: www.excelforum.com/showthread...hreadid=525463