How to Make a Semi-Log Graph on Excel?

How to Make a Semi-Log Graph on Excel
••• rozkmina/iStock/GettyImages

If you are graphing data with exponential growth, such as the data describing the growth of a bacterial colony, using the typical Cartesian axes might result in your being unable to easily see trends, such as increases and decreases, on the graph. In these cases, graphing with semi-log axes is helpful. 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.

    Double-click that axis. Click on the "Scale" tab, then check the box corresponding to "Logarithmic Scale." Your graph will now become semi-logarithmic.

Related Articles

How to Read a Semi-Log Graph
Proper way to Label a Graph
How to Calculate a Normalized Curve
How to Make a Graph on a Graphing Calculator
How to Graph a Function
The Advantages of Bar Graphs
How to Read Log Scale Graphs
Proper way to Label a Graph
How to Graph Linear Inequalities
How to Test Linearity in SPSS
How to Solve for Sigma on a TI83
How to Find Correlation Coefficient & Coefficient of...
How to Draw Pictures on a Graphing Calculator
How to Plot Line Segments on Graphing Calculator
Difference Between a Bar Graph & Pie Chart
How to Find the Slope of a Plotted Line With the TI-84...
How Do I Calculate the Relative Standard Deviation...
How to Find Horizontal Asymptotes of a Function on...
How to Make Excel Calculate the Graph's Slope
How to Analyze Graphs

Dont Go!

We Have More Great Sciencing Articles!