Can I create an Excel chart with two x-axes?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to plot a few series of data against depth. Hence it would look
much better to have depth on the y-axis and the variables on the x-axis.

However I still need different scales for the variables to make this really
work.

Help!
 
ellmcg said:
I'm trying to plot a few series of data against depth. Hence it would
look
much better to have depth on the y-axis and the variables on the x-axis.

However I still need different scales for the variables to make this
really
work.
Click to expand...

If you select the series for you wish to use a secondary axis (using "Format
Data Series", then "Axes") it will initially provide a secondary y-axis, but
if you then go to "Chart Options" and then "Axes", it will allow you to
choose a secondary x-axis (and unselect the secondary y-axis if you wish to
do so).
 
Back
Top