4 replies to this topic

[cardosopedro]

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!

Edited by cardosopedro, 30 October 2009 - 08:53 AM.

[Chakchel]

You can change the scale of your axis in Excel by double clicking on it and then marking the option logarithmic scale.

[K.B.]

In Excel - double-click on plot to open "Format data series" window, then choose "Axis" and pick "Secondary axis".

[cardosopedro]

Thanks for the answers. I'll try it.

[cardosopedro]

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.