| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
HELP!!!!!!!!!! Y By X Chart with points.
Hi,
I am using Excel 2003 and I am trying to build a chart with the following info: Points 1 2 3 4 5 6 7 Variety 1 7.1 5.6 4.8 5.8 4.8 4.2 5.2 Variety 2 5.5 5.5 5.2 6.5 4.3 6.2 3.6 Variety 3 2.3 2.8 5.0 7.6 4.3 6.1 5.7 Variety 4 8.4 8.2 6.1 6.1 6.6 9.0 7.0 Variety 5 15.8 21.8 15.1 7.2 18.0 19.7 12.5 Variety 6 6.2 1.8 1.6 5.9 6.4 7.2 3.6 Variety 7 3.0 4.7 6.6 6.0 4.3 6.4 2.9 What I am trying to do is have the Variety 1 etc on the vertical axis and the point data on the horizontal axis from low to high. There are duplicat amounts in the point data but this is ok. I need the points data on the horizontal axis to be on a range from 0 to the highest. I need them to show up as dots, circles or diamonds, etc. I built a stacked column chart but this is not what I was looking for. Your help on this matter will be greatly apppreciated. If it cannot be done with Excel, then suggest some software that could help me do what I want. Thanks, Curt |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
HELP!!!!!!!!!! Y By X Chart with points.
Hi,
Have a look at these examples of Dot plots. http://www.processtrends.com/pg_charts_dot_plots.htm http://www.exceluser.com/dash/dotplot.htm Cheers Andy Curt Hand wrote: Hi, I am using Excel 2003 and I am trying to build a chart with the following info: Points 1 2 3 4 5 6 7 Variety 1 7.1 5.6 4.8 5.8 4.8 4.2 5.2 Variety 2 5.5 5.5 5.2 6.5 4.3 6.2 3.6 Variety 3 2.3 2.8 5.0 7.6 4.3 6.1 5.7 Variety 4 8.4 8.2 6.1 6.1 6.6 9.0 7.0 Variety 5 15.8 21.8 15.1 7.2 18.0 19.7 12.5 Variety 6 6.2 1.8 1.6 5.9 6.4 7.2 3.6 Variety 7 3.0 4.7 6.6 6.0 4.3 6.4 2.9 What I am trying to do is have the Variety 1 etc on the vertical axis and the point data on the horizontal axis from low to high. There are duplicat amounts in the point data but this is ok. I need the points data on the horizontal axis to be on a range from 0 to the highest. I need them to show up as dots, circles or diamonds, etc. I built a stacked column chart but this is not what I was looking for. Your help on this matter will be greatly apppreciated. If it cannot be done with Excel, then suggest some software that could help me do what I want. Thanks, Curt -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
HELP!!!!!!!!!! Y By X Chart with points.
Hi Andy,
I could not find what I was really looking for so I sent you and email with a picture of a chart I am trying to create. "Andy Pope" wrote: Hi, Have a look at these examples of Dot plots. http://www.processtrends.com/pg_charts_dot_plots.htm http://www.exceluser.com/dash/dotplot.htm Cheers Andy Curt Hand wrote: Hi, I am using Excel 2003 and I am trying to build a chart with the following info: Points 1 2 3 4 5 6 7 Variety 1 7.1 5.6 4.8 5.8 4.8 4.2 5.2 Variety 2 5.5 5.5 5.2 6.5 4.3 6.2 3.6 Variety 3 2.3 2.8 5.0 7.6 4.3 6.1 5.7 Variety 4 8.4 8.2 6.1 6.1 6.6 9.0 7.0 Variety 5 15.8 21.8 15.1 7.2 18.0 19.7 12.5 Variety 6 6.2 1.8 1.6 5.9 6.4 7.2 3.6 Variety 7 3.0 4.7 6.6 6.0 4.3 6.4 2.9 What I am trying to do is have the Variety 1 etc on the vertical axis and the point data on the horizontal axis from low to high. There are duplicat amounts in the point data but this is ok. I need the points data on the horizontal axis to be on a range from 0 to the highest. I need them to show up as dots, circles or diamonds, etc. I built a stacked column chart but this is not what I was looking for. Your help on this matter will be greatly apppreciated. If it cannot be done with Excel, then suggest some software that could help me do what I want. Thanks, Curt -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
HELP!!!!!!!!!! Y By X Chart with points.
Hi,
Any chance of sending a compressed version of the file, 23MB is a little excessive! Cheers Andy Curt Hand wrote: Hi Andy, I could not find what I was really looking for so I sent you and email with a picture of a chart I am trying to create. "Andy Pope" wrote: Hi, Have a look at these examples of Dot plots. http://www.processtrends.com/pg_charts_dot_plots.htm http://www.exceluser.com/dash/dotplot.htm Cheers Andy Curt Hand wrote: Hi, I am using Excel 2003 and I am trying to build a chart with the following info: Points 1 2 3 4 5 6 7 Variety 1 7.1 5.6 4.8 5.8 4.8 4.2 5.2 Variety 2 5.5 5.5 5.2 6.5 4.3 6.2 3.6 Variety 3 2.3 2.8 5.0 7.6 4.3 6.1 5.7 Variety 4 8.4 8.2 6.1 6.1 6.6 9.0 7.0 Variety 5 15.8 21.8 15.1 7.2 18.0 19.7 12.5 Variety 6 6.2 1.8 1.6 5.9 6.4 7.2 3.6 Variety 7 3.0 4.7 6.6 6.0 4.3 6.4 2.9 What I am trying to do is have the Variety 1 etc on the vertical axis and the point data on the horizontal axis from low to high. There are duplicat amounts in the point data but this is ok. I need the points data on the horizontal axis to be on a range from 0 to the highest. I need them to show up as dots, circles or diamonds, etc. I built a stacked column chart but this is not what I was looking for. Your help on this matter will be greatly apppreciated. If it cannot be done with Excel, then suggest some software that could help me do what I want. Thanks, Curt -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Accessing Points in a Line Chart | Charts and Charting in Excel | |||
| Adding comments to points in a chart? | Charts and Charting in Excel | |||
| Charting data points and show a target range on the same chart. | Charts and Charting in Excel | |||
| Excel 2003 xy chart - problem plotting more than 330 points | Charts and Charting in Excel | |||
| Bar Chart To Line Chart for last 3 points only | Charts and Charting in Excel | |||
Linear Mode
