If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
XY Chart - Trouble plotting within defined scale
This is probably a dumb question, but -
I am plotting x & y values that are contained between 1 and 5. There are 29 of these pairs. When I create the chart, there values automatically get spread over the 29 instances, instead of the multiple pairs plotted in a 5 by 5 xy plot. I have spent a lot of timeon this, and it's probably basic. So any help is greatly appreciated. Regards Phill |
#2
|
|||
|
|||
XY Chart - Trouble plotting within defined scale
Phill -
Sounds like you're making a Line chart. Make an XY Scatter chart. The names are a misnomer; the differences have noting to do with lines and markers, but in how the X axis treats its values. Here's some follow up reading, in case you're interested: X Axis: Category or Value? http://peltiertech.com/Excel/ChartsH...ValueAxis.html Scatter Chart or Line Chart? http://pubs.logicalexpressions.com/P...cle.asp?ID=190 - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/Excel/Charts/ _______ PhillM wrote: This is probably a dumb question, but - I am plotting x & y values that are contained between 1 and 5. There are 29 of these pairs. When I create the chart, there values automatically get spread over the 29 instances, instead of the multiple pairs plotted in a 5 by 5 xy plot. I have spent a lot of timeon this, and it's probably basic. So any help is greatly appreciated. Regards Phill |
#3
|
|||
|
|||
XY Chart - Trouble plotting within defined scale
Jon,
Thanks for your references. I tried the line chart, however the chart still forms across the x axis along the 29 points. I had a look at your references, but I am still struggling. The XY plot is supposed to plot pairs, one value against the other (ie. an x value and a y value). What I am trying to do is plot all 29 pairs on a chart with an x and y axis of 5 (ticks on the axis). The maximum value of any of the pair values is 5. Thanks for any further advice. Regards Phill (PhillM) wrote in message . com... This is probably a dumb question, but - I am plotting x & y values that are contained between 1 and 5. There are 29 of these pairs. When I create the chart, there values automatically get spread over the 29 instances, instead of the multiple pairs plotted in a 5 by 5 xy plot. I have spent a lot of timeon this, and it's probably basic. So any help is greatly appreciated. Regards Phill |
#4
|
|||
|
|||
XY Chart - Trouble plotting within defined scale
Phill -
Copy the data and paste it into a reply. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/ _______ PhillM wrote: Jon, Thanks for your references. I tried the line chart, however the chart still forms across the x axis along the 29 points. I had a look at your references, but I am still struggling. The XY plot is supposed to plot pairs, one value against the other (ie. an x value and a y value). What I am trying to do is plot all 29 pairs on a chart with an x and y axis of 5 (ticks on the axis). The maximum value of any of the pair values is 5. Thanks for any further advice. Regards Phill (PhillM) wrote in message . com... This is probably a dumb question, but - I am plotting x & y values that are contained between 1 and 5. There are 29 of these pairs. When I create the chart, there values automatically get spread over the 29 instances, instead of the multiple pairs plotted in a 5 by 5 xy plot. I have spent a lot of timeon this, and it's probably basic. So any help is greatly appreciated. Regards Phill |
Thread Tools | |
Display Modes | |
|
|