I want to plot in the same graph two curves corresponding to two drugs' dose-response curves. The problem is that the concentrations are very different (nM values for drug A and microM for drug B...). How can I put these 2 curves in only 1 graph, but with a logarithmic scale in the x axis?
I'm using Excel or Statview or SPSS...
Thanks!
Full Version: Plotting curves with different scales in the same graph
You can change the scale of your axis in Excel by double clicking on it and then marking the option logarithmic scale.
In Excel - double-click on plot to open "Format data series" window, then choose "Axis" and pick "Secondary axis".
Thanks for the answers. I'll try it.
QUOTE (K.B. @ Oct 30 2009, 07:17 PM) 
In Excel - double-click on plot to open "Format data series" window, then choose "Axis" and pick "Secondary axis".
It worked. However, Excel created another y axis for the 2nd curve. But, what I want is a 2nd scale for the x axis. Thanks again and I hope you can help me.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.