• 0

How to plot semi-log graph in microsoft Excel?


Question

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.

post-173889-1206628850_thumb.jpg

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

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:

post-74203-1206629902_thumb.png

Edited by Napalm Frog
Link to comment
Share on other sites

  • 0
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

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.