KNOWLEDGEBASE - ARTICLE #1193

I use the Remove Baseline analysis to divide all my columns by a control column. But I want to still show the control values on the graph as 1.0 or 100%.

When you divide one column by another, Prism removes the baseline column entirely from the results page and thus from any resulting graph.

It is easy to work around this. Say you have just two columns A and B. You want your resulting graph to show percent of control, so the first bar is 100% by definition and the second shows B/A. Prism doesn't do what you want automatically, since it removes the baseline (A) column from the results. So what you need to do is insert a third column to the data table between column A and B. Now A is the control values, B is an exact duplicate of the control values, and C is the treated values (what used to be column B). The remove baseline analysis will remove column A, but report results for B and C. Since A and B are identical, the results in column B will be 1.0 or 100% and you'll get the graph you want.

Explore the Knowledgebase

Analyze, graph and present your scientific work easily with GraphPad Prism. No coding required.