In biochemistry, the Michaelis-Menten Equation of enzyme kinetics results in a Lineweaver-Burk Plot, also known as a Double Reciprocal Plot. Here’s an example of one such chart.

**Lineweaver Burk Plot and Its Components**

**What Is a Lineweaver-Burk Plot?**

A** Lineweaver-Burk Plot** is the graphical representation of the Michaelis-Menten Equation. The plot is used to determine different types of inhibitions.

** **

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

**Step 1 – Setting Up the Data **

- Compile the raw substrate concentration and initial velocity data as depicted in the picture below.

- Find the reciprocals of both points (i.e.,
**S**and**V**) as shown._{o}

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

**Step 2 – ****Inserting a Scatter Plot**

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

- Excel inserts a
**Scatter Plot**as shown below.

**Read More: **How to Plot Time Series Frequency in Excel

**Step 3 – Modifying the Scatter Plot to Make a Lineweaver-Burk Plot in Excel**

Stretching the **Trendline Backward **results in a Lineweaver-Burk plot.

- Click on a point in the plot, then right-click on it. The
**Context Menu**appears. - Select
**Add Trendline**.

- Excel brings up the
**Format Trendline**side window. - Select
**Linear**(Under**Trendline Options**) - Enter the
**Backward**value**0.07**or any suitable value. - Check
**Display Equation on Chart**.

- Choose a plot design. Here’s an example.

**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 different inhibition reactions.*

**Download the Excel Workbook**

## Related Articles

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