show minor unit and minor grid on log log chart

[mathjunkie]

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?

 

[IRstuff]

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

TTFN

 

[EGT01]

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:
[tt]
X Y
0 2
100 2
[/tt]
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.

 

[mattis]

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 ?

 

[IRstuff]

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

 

[mattis]

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