Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
dot plot - single x axis location with multiple y axis dots
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 "girls" and the other labeled "boys". The y axis would be height. Then above the "girls" 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: http://www.excelforum.com/member.php...o&userid=32065 View this thread: http://www.excelforum.com/showthread...hreadid=525463 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
dot plot - single x axis location with multiple y axis dots
Eric -
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 "Girls" and "Boys": http://peltiertech.com/Excel/Charts/ArbitraryAxis.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "EJF" wrote in message ... 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 "girls" and the other labeled "boys". The y axis would be height. Then above the "girls" 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: http://www.excelforum.com/member.php...o&userid=32065 View this thread: http://www.excelforum.com/showthread...hreadid=525463 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
dot plot - single x axis location with multiple y axis dots
Thanks! That works well. -- EJF ------------------------------------------------------------------------ EJF's Profile: http://www.excelforum.com/member.php...o&userid=32065 View this thread: http://www.excelforum.com/showthread...hreadid=525463 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Indentify value from multiple values in a single cell | Excel Worksheet Functions | |||
Multiple plot areas | Charts and Charting in Excel | |||
how do I plot on the z axis? | Charts and Charting in Excel | |||
Multiple rows of data on a single axis (charting) | Charts and Charting in Excel | |||
Plot a line? Set dymanic axis Max min | Charts and Charting in Excel |