On Fri, 21 Jul 2006, in microsoft.public.excel.charting,
John Broderick said:

Lets say I want to plot some data (on a scatter chart) which is a function
of temperature. For convenience I would like to show two x-axes which gives
the correpsonding x-values in Fahrenheit and Celcius. So then I could chose
to plot(x_fahrenheit, y1) on x-axis1 or plot(x_celsius, y2) on x-axis2
(forgive the Matlab plot notation) and could choose whether to read off the
x-axis values in Fahrenheit or Celsius directly from the plot.
Can this be done in Excel (or Matlab). What if I needed 3 x-axes?

Using the Excel-provided axes, you can get two, fairly easily, as long
as there is at least one set of data using each axis. In the "Format
Data Series" dialogue there is a tab called "Axis" which lets you choose
a primary or secondary axis. You can create a dummy data range to do
nothing but provide the second axis if you like, just make it invisible
so it's not intruding on your chart.

To make three or more axes, you are out of luck as far as Excel's basic
abilities are concerned, but there are several web sites by Tushar
Mehta, Jon Peltier and the other Microsoft MVPs who post here regularly,
that show you how to use data ranges to make fake axes that look like
the real thing.

http://www.tushar-mehta.com/excel/ne...ble_log_scale/
http://peltiertech.com/Excel/Charts/axes.html

If you learn how to do that, you can have dozens of axes if you want
them.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.