vip_565 Posted March 27, 2008 Share Posted March 27, 2008 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. Link to comment https://www.neowin.net/forum/topic/628068-how-to-plot-semi-log-graph-in-microsoft-excel/ Share on other sites More sharing options...
0 Napalm Frog Posted March 27, 2008 Share Posted March 27, 2008 (edited) 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 Link to comment https://www.neowin.net/forum/topic/628068-how-to-plot-semi-log-graph-in-microsoft-excel/#findComment-589295966 Share on other sites More sharing options...
0 vip_565 Posted March 27, 2008 Author Share Posted March 27, 2008 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 https://www.neowin.net/forum/topic/628068-how-to-plot-semi-log-graph-in-microsoft-excel/#findComment-589296010 Share on other sites More sharing options...
Question
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.
Link to comment
https://www.neowin.net/forum/topic/628068-how-to-plot-semi-log-graph-in-microsoft-excel/Share on other sites
2 answers to this question
Recommended Posts