Like this example:

http://peltiertech.com/Excel/ChartsH...html#manyxoney

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"jimF" wrote in message
...
I just figured it out. I assumed the x values had to be the same for all
curves. By making the yvalues the same(independent) and vary the x
values(dependent) you get the curves to progress up instead of across.

"Jon Peltier" wrote:

This example helps illustrate what Andy is describing:

http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"Andy Pope" wrote in message
...
Hi,

Try using the xy scatter rather than the Line chart. That way you can
specify the ranges for both x and y values. You will probably need to
generate a set of default values for the y axis.

Cheers
Andy

jimF wrote:
how do you make the x axis the dependent variable and the Y axis the
independent variable so that the curves progress up instead of across?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info