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

Get FREE Advanced Excel Exercises with Solutions!

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.

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.


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,

Components of Lineweaver Burk Plot

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


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

Data for making a Lineweaver Burk plot

  • Find the reciprocals of both raw data (i.e., S and Vo) as instructed in the picture.


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


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.

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

Modifying the Scatter Plot as a Lineweaver Burk Plot in Excel

  • 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


Related Articles

Maruf Islam
Maruf Islam

My self, Maruf Islam, an engineer and Excel & VBA Content developer on Exceldemy. I enjoy solving problems, finding workable solutions, and most of the part I really like to take on challenges. On Exceldemy I write articles discussing various way outs of Microsoft Excel's stuck ons.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo