two x axes with one y axis, different data on x


G

Guest

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.
 
Ad

Advertisements

J

Jon Peltier

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
http://PeltierTech.com/
_______
 
Ad

Advertisements

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

X and Y axes 3
x and y axis 5
switch x/y axes 3
Swich X and Y axes 1
Secondary X- and Y- Axes 1
Switch x and y axes 3
Swap the X and Y axes 1
put data on x axis on the y axis 2

Top