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

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!

Hi,

Here's an explanation of how to get 2 x-axis.
http://www.andypope.info/tips/tip008.htm

Cheers
Andy

ellmcg wrote:
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!

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

"ellmcg" wrote in message
...
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.

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).
--
David Biddulph