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.

**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}**How to Make a Lineweaver Burk Plot in Excel: Step-by-Step Procedure**

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}

**Read More: **How to Plot Semi Log Graph in Excel

**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 Plot Time Series Frequency in Excel

**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 in the plot, then right-click on it. The
**Context Menu**appears. - Then, select
**Add Trendline**.

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

- Firstly, select
**Linear**(Under**Trendline Options**) - Then, enter the
**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: **How to Make a Time Series Graph in Excel

**â§ 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.*

**Download Excel Workbook**

**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.

## Related Articles

**<< Go Back To How to Create a Chart in Excel |Â Excel Charts |Â Learn Excel**