×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Charts

Charts

(OP)
I am trying to duplicate a curve using logorithmic scale in excel without any luck. I have attached the curves I am trying to replicate. I am looking for some direction on settng this curve.

RE: Charts

Could you expand on your "without any luck" statement?  Do you have the data for the curves?  Could you attach your spreadsheet to show what is happening?

It doesn't look like a difficult graph to plot.

David

RE: Charts

(OP)
I want to set up a generic graph on the log scale along the x axis from 0.1 to 10 & along the Y  axis from 0.01 to 10. I go to insert and choose scatter graph but unable to produce a generic logorithmic graph. My goal is to save the workbook that has this graph and past my raw data into it.

RE: Charts

Did you generically change the axis scales to logarithmic?

 

RE: Charts

(OP)
When using some data I was able to change both axis to logarithmic but I wasn't able to have the horizontal axis and the vertical axis log scales differnt. I am runing excel 2010.  

RE: Charts

More detail would help us understand what the problem is.

There is a separate dialog box for each axis, so I don't understand why you can't set different scale limits for each axis.

You can access the dialog box either by right clicking on each axis and select format axis, or select the chart, then the Chart-Tools, Layout Tab, then Axes, Primary Horizontal or Vertical axis, More Horizontal/Vertical axis options.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
 

RE: Charts

(OP)
Is it possible to force excell to put a gridline @ sqrt(2) also?

RE: Charts

(OP)
chemebabak,

That worked great!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources