# How to Make a Lineweaver Burk Plot in Excel (with Easy Steps)

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 Vo. Y-axis of the Lineweaver Burk plot that is reciprocal of velocity, [1/Vo].

Maximum Velocity

Maximum Velocity of the enzyme-inhibited reaction, Vmax. Y-axis interception of the plot is reciprocal of maximum velocity, [1/Vmax].Â

Michaelis Constant

Michaelis Constant, Km is the measurement of enzyme affinity. X-axis interception of the plot is reciprocal of Michaelis Constant, [-1/Km].

## 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 (Vo). 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 Vo) as instructed in the picture.

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.

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

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

## 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

Get FREE Advanced Excel Exercises with Solutions!
Maruf Islam

MARUF ISLAM is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a superhero tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including ABACUS, AutoCAD, Rhinoceros, Maxsurf, and Hydromax. He got his B.Sc in Naval Architecture & Marine Engineering from BUET, and now he's switched gears, working as a content developer. In this role, he creates techy content... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF