×
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

show minor unit and minor grid on log log chart

show minor unit and minor grid on log log chart

show minor unit and minor grid on log log chart

(OP)
I see on a previous thread that the major units on log log have to be powers of 10. If someone knows how to change this, let me know.
My question is, how do I show minor gridlines and labels on log log charts. For example, the chart runs from 1 to 100 on x axis, and 1 to 100 on y axis. I want to show gridlines between 1 and 2, and also between 10 and 20, and between 100 and 200. Is this possible without interpolating and using drawing tools to do it?

RE: show minor unit and minor grid on log log chart

Minor gridlines below 10/decade cannot be done, at least, not in Excel2000

TTFN

RE: show minor unit and minor grid on log log chart

Mathjunkie,

If you hadn't thought about this, you could just add some additional "series" to your graph so that the additional gridlines you want are actually plotted as part of your graph.  

Of course this requires some extra effort but not a lot.  For example, to show a minor gridline at Y value of 2, plot the following:

       X       Y
       0       2
       100     2

This should give you a horizontal line at Y=2.  Then just repeat for your other gridlines.  You will want to minimize the formatting for those series so make them all the same color and display with markers, etc.  You could display the data labels if you want to show the value of the gridline or just add a text box with appropriate value in the appropriate place.

RE: show minor unit and minor grid on log log chart

I don´t have any solution and I´ve tried many of the other plot programs on the market and only ORIGIN can do a half decent plot with a logritmic axis where the scale is say 40 to 70 with labels for 40, 50 , 60 and 70...
This is very annoying especially when dealing with e.g. fatigu e data. You often see published data where there is labels for  
1,10 and 100 MPa but the actual data points lie between 100 and 150... this does´t look good at all.
Has anyone seen a program that can do decent plots ?

RE: show minor unit and minor grid on log log chart

Axum, from Mathsoft, which, unfortunately, is no longer a product, could also do that.  

Have never used Origin, so don't have any basis for comparison

TTFN

RE: show minor unit and minor grid on log log chart

By accident i found a GNU program that could do what I´ve always wanted Excel to do, RLplot (http://rlplot.sourceforge.net/)can do nice looking plots with log-log scale with major units of 10,20,30 and minor ticks at  11,12 etc. and many other things. The program for windows is a single binary file of 880kB ... no installation needed. It works fine on my Linux computer at home to... I´m starting to sound like a salesman for the program now but i´m not selling anything. I'm only impressed.

Mattias

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