software

I need to have two x-axis with two different types of data (ex: oxygen and
temp, one on top, one on the bottom) with one y-axis (depth, on the left).
The same basic concept as having 2 y-axes but with the x-axes.

Make your XY chart with both sets of data. Double click one series, and on
the Axis tab, select Secondary. Excel helpfully gives you a secondary Y
axis, but only the primary X axis. Select Chart Options from the Chart menu,
and on the Axes tab, uncheck the secondary Y box, and check the secondary X
box.

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

quot;Kris@Cooperquot; gt; wrote in message
...
gt;I need to have two x-axis with two different types of data (ex: oxygen and
gt; temp, one on top, one on the bottom) with one y-axis (depth, on the left).
gt; The same basic concept as having 2 y-axes but with the x-axes.
Thanks, i also found the xy switch add-on which moved my depth data to the
y-axis and then everything was fixed when i did what you suggested below.

Thanks

quot;Jon Peltierquot; wrote:

gt; Make your XY chart with both sets of data. Double click one series, and on
gt; the Axis tab, select Secondary. Excel helpfully gives you a secondary Y
gt; axis, but only the primary X axis. Select Chart Options from the Chart menu,
gt; and on the Axes tab, uncheck the secondary Y box, and check the secondary X
gt; box.
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; quot;Kris@Cooperquot; gt; wrote in message
gt; ...
gt; gt;I need to have two x-axis with two different types of data (ex: oxygen and
gt; gt; temp, one on top, one on the bottom) with one y-axis (depth, on the left).
gt; gt; The same basic concept as having 2 y-axes but with the x-axes.
gt;
gt;
gt;