software

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?

You're going to need to give us some more info. What kind of chart are you
talking about? For instance, bars can go horizontal (Bar Chart) instead
of vertical (Column Chart.)

This doesn't sound too difficult, but we can't help much without some more
specifics. Why not give us a couple of short columns of numbers and a
better description of what you need the chart to look like.

quot;jimFquot; gt; wrote in message
...
gt; how do you make the x axis the dependent variable and the Y axis the
gt; independent variable so that the curves progress up instead of across?
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:
gt; how do you make the x axis the dependent variable and the Y axis the
gt; independent variable so that the curves progress up instead of across?

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

This example helps illustrate what Andy is describing:

peltiertech.com/Excel/Charts/Y_CategoryAxis.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______quot;Andy Popequot; gt; wrote in message
...
gt; Hi,
gt;
gt; Try using the xy scatter rather than the Line chart. That way you can
gt; specify the ranges for both x and y values. You will probably need to
gt; generate a set of default values for the y axis.
gt;
gt; Cheers
gt; Andy
gt;
gt; jimF wrote:
gt;gt; how do you make the x axis the dependent variable and the Y axis the
gt;gt; independent variable so that the curves progress up instead of across?
gt;
gt; --
gt;
gt; Andy Pope, Microsoft MVP - Excel
gt; www.andypope.info
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.

quot;Jon Peltierquot; wrote:

gt; This example helps illustrate what Andy is describing:
gt;
gt; peltiertech.com/Excel/Charts/Y_CategoryAxis.html
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt;
gt; quot;Andy Popequot; gt; wrote in message
gt; ...
gt; gt; Hi,
gt; gt;
gt; gt; Try using the xy scatter rather than the Line chart. That way you can
gt; gt; specify the ranges for both x and y values. You will probably need to
gt; gt; generate a set of default values for the y axis.
gt; gt;
gt; gt; Cheers
gt; gt; Andy
gt; gt;
gt; gt; jimF wrote:
gt; gt;gt; how do you make the x axis the dependent variable and the Y axis the
gt; gt;gt; independent variable so that the curves progress up instead of across?
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Andy Pope, Microsoft MVP - Excel
gt; gt; www.andypope.info
gt;
gt;
gt;

Like this example:

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

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

quot;jimFquot; gt; wrote in message
...
gt;I just figured it out. I assumed the x values had to be the same for all
gt; curves. By making the yvalues the same(independent) and vary the x
gt; values(dependent) you get the curves to progress up instead of across.
gt;
gt; quot;Jon Peltierquot; wrote:
gt;
gt;gt; This example helps illustrate what Andy is describing:
gt;gt;
gt;gt; peltiertech.com/Excel/Charts/Y_CategoryAxis.html
gt;gt;
gt;gt; - Jon
gt;gt; -------
gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; Peltier Technical Services
gt;gt; Tutorials and Custom Solutions
gt;gt; PeltierTech.com/
gt;gt; _______
gt;gt;
gt;gt;
gt;gt; quot;Andy Popequot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hi,
gt;gt; gt;
gt;gt; gt; Try using the xy scatter rather than the Line chart. That way you can
gt;gt; gt; specify the ranges for both x and y values. You will probably need to
gt;gt; gt; generate a set of default values for the y axis.
gt;gt; gt;
gt;gt; gt; Cheers
gt;gt; gt; Andy
gt;gt; gt;
gt;gt; gt; jimF wrote:
gt;gt; gt;gt; how do you make the x axis the dependent variable and the Y axis the
gt;gt; gt;gt; independent variable so that the curves progress up instead of across?
gt;gt; gt;
gt;gt; gt; --
gt;gt; gt;
gt;gt; gt; Andy Pope, Microsoft MVP - Excel
gt;gt; gt; www.andypope.info
gt;gt;
gt;gt;
gt;gt;