Jump to content


- - - - -

Plotting curves with different scales in the same graph


4 replies to this topic

#1 cardosopedro

    Veteran

  • Active Members
  • PipPipPipPipPip
  • 106 posts

Posted 30 October 2009 - 08:51 AM

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.


#2 Chakchel

    Enthusiast

  • Active Members
  • PipPip
  • 33 posts

Posted 30 October 2009 - 09:17 AM

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

#3 K.B.

    Veteran

  • Active Members
  • PipPipPipPipPip
  • 179 posts

Posted 30 October 2009 - 10:17 AM

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

#4 cardosopedro

    Veteran

  • Active Members
  • PipPipPipPipPip
  • 106 posts

Posted 30 October 2009 - 02:30 PM

Thanks for the answers. I'll try it.

#5 cardosopedro

    Veteran

  • Active Members
  • PipPipPipPipPip
  • 106 posts

Posted 30 October 2009 - 02:46 PM

View PostK.B., on Oct 30 2009, 07:17 PM, said:

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.





Home - About - Terms of Service - Privacy - Contact Us

©1999-2011 Protocol Online, All rights reserved.