Using Exel to plot target graphs.

[Ferric Toes]

I have spent quite a bit of time plotting Exel graphs from the results obtained in testing soil and rock samples with my magnetic viscosity meter. Data can be plotted in linear, semi-log and log-log form, which is fine. The first plot attached is semi-log on which a pure single exponential object, such as a thin gold ring, would appear as a straight line plot. Rocks and magnetically mineralised soil will have a power law decay which requires a log-log plot to show a straight line. In semi-log it appears as in the first attachment.



This shows four plots and that the exponents differ. The red trace is a piece of the ironstone that gave Kingswood trouble when ground balancing his VMH3CS detector. This has an x^-1.133 decay. Soil from Red Hill, Virginia, has a x^-1.037 decay, as shown by the top purple trace. The other two plots are material from other area.

The problem I have is that when the graph is switched to log-log, I lose the 10uS X axis spacing that I have in the linear and semi-log plots which show the time spacing of the sample pulse. All I can get is the 10, 100, 1000 etc, axes, but without the minor axes that identify the sample points.



This is a second sample of Red Hill soil which gives x^-1.041 as do three other samples. All samples in these tests are 10gm weight so that I can also compare them for magnetic susceptibility in a different instrument.

Does anyone know how to get these minor axes on the X axis? I have scoured several books on Exel without success.

Eric.

[green]

I have spent quite a bit of time plotting Exel graphs from the results obtained in testing soil and rock samples with my magnetic viscosity meter. Data can be plotted in linear, semi-log and log-log form, which is fine. The first plot attached is semi-log on which a pure single exponential object, such as a thin gold ring, would appear as a straight line plot. Rocks and magnetically mineralised soil will have a power law decay which requires a log-log plot to show a straight line. In semi-log it appears as in the first attachment.

[ATTACH]42727[/ATTACH]

This shows four plots and that the exponents differ. The red trace is a piece of the ironstone that gave Kingswood trouble when ground balancing his VMH3CS detector. This has an x^-1.133 decay. Soil from Red Hill, Virginia, has a x^-1.037 decay, as shown by the top purple trace. The other two plots are material from other area.

The problem I have is that when the graph is switched to log-log, I lose the 10uS X axis spacing that I have in the linear and semi-log plots which show the time spacing of the sample pulse. All I can get is the 10, 100, 1000 etc, axes, but without the minor axes that identify the sample points.

[ATTACH]42728[/ATTACH]

This is a second sample of Red Hill soil which gives x^-1.041 as do three other samples. All samples in these tests are 10gm weight so that I can also compare them for magnetic susceptibility in a different instrument.

Does anyone know how to get these minor axes on the X axis? I have scoured several books on Exel without success.

Eric.

Try making the units major and minor = 10

[Skippy]

I haven't tried this tutorial, Eric, but it seems to describe major/minor scale changing:
http://smallbusiness.chron.com/set-i...rts-48666.html

[Ferric Toes]

Try making the units major and minor = 10

Yes, I tried that but no change.

Eric.

[green]

Yes, I tried that but no change.

Eric.

I haven't figured Excel either but it worked for me.
Did you add minor grid lines? Right click on X scale and add minor grid lines. I do it by habit and forgot to mention it.

[Ferric Toes]

I haven't figured Excel either but it worked for me.
Did you add minor grid lines? Right click on X scale and add minor grid lines. I do it by habit and forgot to mention it.

Brilliant, you helped me find it. I clicked on the X scale as I had before, but the minor axis options was set to 'automatic' with the result that nothing appears. However, switching to 'solid line' and the horizontal minor axes all appear at 10uS intervals. I can then edit them to be dashed or dotted. Just what I wanted.

Eric.