In biochemistry, the **Lineweaver Burk Equation** of energy kinetics results in a **Lineweaver Burk Plot** also known as a **Double Reciprocal Plot**. Therefore, users may wonder how to make a Lineweaver Burk plot in Excel.

In this article, we demonstrate step-by-step procedures to make a Lineweaver Burk plot in Excel.

**Table of Contents**hide

**Download Excel Workbook**

**Lineweaver Burk Plot and Its Components**

**What Is Lineweaver Burk Plot?**

A** Lineweaver Burk Plot** is the graphical representation of the **Lineweaver Burk Equation**. The plot is used to compare with no inhibitor to identify the effectiveness of the inhibitor. The following describes the Lineweaver Burk plot’s components,

** **

**Substrate Concentration**

**Substrate Concentration**,** S**. X-axis of the Lineweaver Burk plot that is reciprocal of substrate concentration, [**1/S**].

**Initial Velocity**

**Initial Velocity** during an enzyme-inhibited reaction, **V** or **V _{o}**. Y-axis of the Lineweaver Burk plot that is reciprocal of velocity, [

**1/V**].

_{o}**Maximum Velocity**

**Maximum Velocity** of the enzyme-inhibited reaction, **V _{max}**. Y-axis interception of the plot is reciprocal of maximum velocity, [

**1/V**].

_{max}

**Michaelis Constant**

**Michaelis Constant**, **K _{m }**is the measurement of enzyme affinity. X-axis interception of the plot is reciprocal of Michaelis Constant, [

**-1/K**].

_{m}**Step-by-Step Procedures to Make a Lineweaver Burk Plot in Excel**

Making a **Lineweaver Burk** plot requires data on **Substrate Concentration** (**S**) and** Initial Velocity** (**V _{o}**). Reciprocals of those result in displaying a

**Lineweaver Burk**plot.

Go through the following steps to make a Lineweaver Burk plot in Excel.

**Step 1: Setting Up the Data **

Users need to compile the raw substrate concentration and initial velocity data as depicted in the picture below.

- Find the reciprocals of both raw data (i.e.,
**S**and**V**) as instructed in the picture._{o}

**Step 2: ****Inserting a Scatter Plot**

After setting up the data, users need to insert a **Scatter Plot**. As we mentioned earlier, stretching the scatter plot trendline backward results in a lineweaver burk plot.

- Highlight the reciprocals, leaving the first non-value entries, and then go to
**Insert**>**Insert Scatter**(inside**Charts**section) > Click**Scatter**.

- Excel inserts a
**Scatter Plot**as shown in the latter image, instantly.

**Read More:** **How to Create a Chart from Selected Range of Cells in Excel**

**Similar Readings**

**How to Plot Semi Log Graph in Excel (with Easy Steps)****Plot Sieve Analysis Graph in Excel (with Quick Steps)****How to Make an X Y Graph in Excel (With Easy Steps)**

**Step 3: Modifying Scatter Plot to Make a Lineweaver Burk Plot in Excel**

As for now, we’ve inserted a **Scatter Plot** using the reciprocals. Stretching the scatter plot **Trendline Backward **results in a Lineweaver Burk plot.

- Click on a point on the plot, then right-click on it. The
**Context Menu**. - Then, select
**Add Trendline**.

- Excel brings up the
**Format Trendline**side window. In the window,

- Firstly, select
**Linear**(Under**Trendline Options**) - Then, enter
**Backward**value**0.07**or any suitable value. - Finally, tick
**Display Equation on Chart**

- Choose a preferable plot design. Finally, the Lineweaver Burk plot may look like the screenshot below.

**Read More: ****Plotting Row Number Instead of Value in Excel (with Easy Steps)**

**⧭ Notes: ***The Lineweaver Burk Plot may have a different depiction depending on the intensity of its components. Therefore, the following image displays multiple Lineweaver Burk plots distinguishing between inhibition and no inhibition reactions.*

**Conclusion**

This article discusses the step-by-step procedures of making a **Lineweaver Burk Plot** in Excel. We hope this article sheds enough light on making a Lineweaver Burk plot to enable you to make one.

Do check out our awesome website,** Exceldemy,** to find interesting articles on Excel