How to plot semi-log graph in microsoft Excel?

[vip_565]

I want to plot a semi-log plot (logarithmic scale) in excel along with X-axis lines. Can anyone

tell how to do?

(i,e.): SIEVE ANALYSIS: Subgrade Gradation Plot

Over SIEVE No., Down (equivalent) "IN" OR "MM" of SIEVE no.

[Napalm Frog]

Once you have the data in, you can go into the properties of the x-axis and just change it from linear to logarithmic, and that should do it. Oddly enough I just did it the other day for a flood-frequency graph, lol.

You can get into it by right-clicking the axis, then click "format axis" to get to the following:

Edited March 27, 2008 by Napalm Frog

[vip_565]

  Napalm Frog said:

Once you have the data in, you can go into the properties of the x-axis and just change it from linear to logarithmic, and that should do it. Oddly enough I just did it the other day for a flood-frequency graph, lol.

Thank you for help :D