Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Plot Michaelis Menten Graph in Excel (With Easy Steps)

In this article, we will learn to plot Michaelis Menten graph in Excel. We use the Michaelis Menten equation to plot the graph. Generally, it is used to analyze the kinetic data of enzymes. It explains the effect of substrate concentration on enzymes. Today, we will show step-by-step procedures to plot Michaelis Menten’s graph in Excel. We will also learn to extract the value of the Michaelis Menten constant. So, without further delay, let’s start the discussion.


Download Practice Workbook

You can download the practice workbook from here.


What Is Michaelis Menten Graph?

In the Michaelis Menten graph, we plot the Reaction Velocity (V) on the Yaxis and the Substrate Concentration ([S]) on the Xaxis. The graph follows the equation below:

V = (Vmax*[S])/([S]+Km)

It is a zero-order equation.

Here,

V = Initial velocity of reaction

Vmax = Maximum velocity of reaction

[S] = Concentration of Substrate

Km = Michaelis Menten Constant

At low substrate concentration, the equation becomes:

V = (Vmax*[S])/Km

It is a first-order equation.


Step-by-Step Procedures to Plot Michaelis Menten Graph in Excel

To explain the steps, we will use a dataset that contains Substrate Concentration, [S]. We will calculate the Reaction Velocity (V) with the Michaelis Menten equation. In the beginning, we will use educated values of Km and V-max. Later, we will find the value of Km and V-max using the observed and calculated Velocity. So, let’s go through the following steps to learn the way to plot Michaelis Menten’s graph.

how to plot michaelis menten graph excel


STEP 1: Insert Michaelis Menten’s Constant and V-max Values

  • In the first place, you need to insert educated values of Km and V-max.
  • Let, the values of Km and V-max are 10.
  • Here, we have inserted 10 in both Cell F4 and Cell F5.

Insert Michaelis Menten’s Constant and V-max Values

Read More: Plotting Row Number Instead of Value in Excel (with Easy Steps)


STEP 2: Calculate Value of Initial Velocity

  • Secondly, we need to calculate the value of the initial velocity.
  • To do that, we will use Michaelis Menten’s equation.
  • Select Cell C5 and type the formula below:
=($F$5*B5)/(B5+$F$4)

Calculate Value of Initial Velocity

Here, Cell F5 contains Km, Cell F4 stores V-max, and Cell B5 stores the Substrate Concentration [S].

  • After that, press Enter and drag the Fill Handle down.

Calculate Value of Initial Velocity

  • As a result, you will see the Velocity corresponding to the Concentration.

Read More: How to Create a Chart from Selected Range of Cells in Excel


STEP 3: Plot Michaelis Menten Graph with Calculated Velocity

  • To plot the graph, you need to select the values of Concentration and corresponding Velocity.
  • Here, we have selected the range B4:C14.

Plot Michaelis Menten Graph with Calculated Velocity

  • After that, go to the Insert tab and click on the Insert Scatter icon. A drop-down menu will appear.
  • Select Scatter with Smooth Lines and Markers option from the drop-down menu.

Plot Michaelis Menten Graph with Calculated Velocity

  • As a result, you will see the plot on the sheet.

Plot Michaelis Menten Graph with Calculated Velocity

  • After changing the axis and chart titles, the graph will look like the picture below.

Plot Michaelis Menten Graph with Calculated Velocity

Read More: How to Plot Graph in Excel with Multiple Y Axis (3 Handy Ways)


STEP 4: Determine Initial Velocity Along with Observed Velocity

  • In STEP 2, we calculated the initial velocity with a formula. In that case, we didn’t have absolute values of Km and V-max. Also, there was no observed velocity.
  • If you have Observed Velocity like the dataset below, you can calculate the initial velocity as well as the values of Km and V-max.

Determine Initial Velocity Along with Observed Velocity

  • At this moment, select Cell D5 and type the formula below:
=($C$17*B5)/(B5+$C$16)

Determine Initial Velocity Along with Observed Velocity

  • Press Enter and drag the Fill Handle down.


STEP 5: Find Difference Between Observed and Calculated Velocities

  • After calculating velocity with the Michaelis Menten equation, we need to find the difference between the observed and calculated velocities.
  • For that purpose, select Cell E5 and type the formula below:
=C5-D5

Find Difference Between Observed and Calculated Velocities

  • Now, press Enter and drag down the Fill Handle to see the results.

Find Difference Between Observed and Calculated Velocities


STEP 6: Find Sum of Square of Differences

  • To find the best values for Km and V-max, we need to determine the sum of squares of the differences.
  • To do so, select Cell E17 and type the formula below:
=SUMSQ(E5:E14)

Find Sum of Square of Differences

Here, we have used the SUMSQ function to calculate the summation of squares of the differences.

  • Press Enter to see the result.
  • For best values of Km and V-max, the Sum of Squares of Differences must be minimum.

Find Sum of Square of Differences


STEP 7: Plot Michaelis Menten Graph with Both Observed & Calculated Velocities

  • To plot the graph with both observed and calculated velocities, select the range B4:D14.

Plot Michaelis Menten Graph with Both Observed & Calculated Velocities

  • After that, go to the Insert tab and click on the Insert Scatter icon. A drop-down menu will appear.
  • Select Scatter with Smooth Lines and Markers option from the drop-down menu.

  • As a result, you will see the graph of both Observed and Calculated velocities.

Plot Michaelis Menten Graph with Both Observed & Calculated Velocities

Read More: How to Plot Multiple Lines in One Graph in Excel


STEP 8: Find Michaelis Menten’s Constant and V-max

  • To find Km and V-max for the observed values, we need to calculate the minimum value of the sum of squares of the differences.
  • For that purpose, we need to take the help of the Solver Add-in.
  • Go to the Data tab and click on the Solver option from the Analysis section.
  • If you don’t find the Solver Add-in, then you can visit this link.

Find Michaelis Menten’s Constant and V-max

  • In the Solver Parameters box, type the cell that contains the value of Sum of Squares of Differences in the Set Objective field. In our case, that is Cell E17.
  • Then, select Min.
  • After that, type the cells that contain the values of Km and V-max in the “By Changing Variable Cells” field.
  • Here, we have typed $C$16:$C$17.
  • Click Solve to proceed.

Find Michaelis Menten’s Constant and V-max

  • In the following step, click OK to move forward.

  • Finally, you will find the desired results like the picture below.

Find Michaelis Menten’s Constant and V-max


STEP 9: Insert Half V-max Value in Graph

  • To insert the Half V-max value, you need to create a chart like the picture below.
  • Here, Cell B20 stores 0. Also, Cell B21 and Cell B22 store the value of Km.
  • On the other hand, Cell C20 and Cell 21 contain the Half V-max value. That means, C17/2. And Cell C22 stores 0.

Insert Half V-max Value in Graph

  • After creating the Half V-max table, select the graph and rightclick on it. A menu will appear.
  • Click on the Select Data option from there.

  • Then, select Add from the Select Data Source box.

Insert Half V-max Value in Graph

  • Then, select the Series Name, X-values, and Y-values.
  • Here, Cell 19 is the Series Name, range B20:B22 is the X-values, and range C20:C22 is the Yvalues.
  • After inserting the values, click OK.

  • Again, click OK in the Select Data Source box.

  • As a result, you will see a graph like the picture below.

Insert Half V-max Value in Graph

Read More: How to Make a Graph from a Table in Excel (5 Suitable Ways)


STEP 10: Change Series Chart Type

  • Finally, we need to change the chart type for the Half V-max value graph.
  • To do so, select the Half V-max value graph first and then, rightclick on it. A menu will appear.
  • Select Change Series Chart Type from there.

Change Series Chart Type

  • In the Change Chart Type box, change the Chart Type of the Half V-max Value graph to Scatter with Straight Lines and Markers.
  • Then, click OK.


Final Output

  • In the end, you will get the desired point where Km is 9.115 and V-max is 7.328.

Final Output


Conclusion

In this article, we have demonstrated step-by-step procedures to Plot Michaelis Menten Graph in Excel. I hope this article will help you to perform your tasks efficiently. Furthermore, we have also added the practice book at the beginning of the article. To test your skills, you can download it to exercise. Also, you can visit the ExcelDemy website for more articles like this. Lastly, if you have any suggestions or queries, feel free to ask in the comment section below.


Related Articles

Mursalin

Mursalin

Hi there! This is Mursalin. I am an Excel and VBA content developer at ExcelDemy. I am always motivated to gather knowledge from different sources and find solutions to problems in easier ways. I am currently working and doing research on Microsoft Excel. Here I will be posting articles related to Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo