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.
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, S. X-axis of the Lineweaver Burk plot that is reciprocal of substrate concentration, [1/S].
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 of the enzyme-inhibited reaction, Vmax. Y-axis interception of the plot is reciprocal of maximum velocity, [1/Vmax].
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.
- 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.
- 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.
⧭ 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.
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