View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
John Broderick John Broderick is offline
external usenet poster
 
Posts: 4
Default Dual x-axis chart

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?

Thanks.