Plotting curves with different scales in the same graph - (Oct/30/2009 )
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...
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.
K.B. on Oct 30 2009, 07:17 PM said:
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.