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