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

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

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

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