Once you have used Excel to create a set of regular axes, converting the axes to semi-logarithmic axes in Excel is far from difficult.

Type the name of your independent variable at the beginning of the A column in Excel.

For instance, if you are graphing time versus bacterial growth, type Time at the top of the first column.

Likewise, type Bacterial Growth at the top of the second column (the B column).

Use the Chart tool to create a graph that plots the independent variable, on the x-axis, versus the dependent variable, on the y-axis.

Decide which axis you would like to make logarithmic: a logarithmic graph makes both axes logarithmic, while a semi-log graph makes only one of the axes logarithmic.

Click on the Scale tab, then check the box corresponding to Logarithmic Scale.

References Southern Illinois University Carbondale: Graphing Using Spreadsheets About the Author Tricia Lobo has been writing since 2006.

Lobo earned her Bachelor of Science in biomedical engineering, with distinction, from Yale in 2010.

Find Your Next Great Science Fair Project GO Science Math Projects News About Us Accessibility Statement Terms of Use Privacy Policy Copyright Policy Contact Us Careers Manage Preferences Copyright 2021 Leaf Group Ltd.

Cross; Dont Go We Have More Great Sciencing Articles How to Read a Semi-Log Graph How to Graph Biology Lab Experiments Proper way to Label a Graph How to Find Correlation Coefficient Coefficient of Determination on the TI-84 Plus How to Solve for Sigma on a TI83 How to Graph Parabolas on a TI-84 Calculator.

Growth Curve On Graph Pad