How to Create a 100% Stacked Column Graph

Excel uses the term "100% stacked column" graph to refer to a stacked bar graph where the sum of all slices is 100. GraphPad Prism 6 lets you make that graph in two different ways.

Excel uses the term "100% stacked column" graph to refer to a stacked bar graph where the sum of all the slices is 100. Prism 6 lets you make that graph in two ways.

1

As a Parts of Whole Graph

Parts of whole data are often plotted as pie charts, but Prism lets you show it as a stack if you want (horizontal or vertical). When plotted this way, Prism doesn't show any axis, so you get a visual sense of the division with no numbers, unless you ask Prism to superimpose each percentage value on each slice.

Note: A parts of whole graph plots data you entered into one column (without any subcolumns). If you want your graph to have several stacks, you'll need to make them individually, and then combine them on a layout.

2

As a Stacked Bar Graph

This is generally a better approach, as it lets you create several stacks in one graph. Here is how to do it:

A

Enter data onto a Grouped table. Each row in the table becomes one stack in the graph.

B

If you enter the data so the values already sum to 100, you can plot these directly.

If your values don't sum to 100, Prism can normalize them so they do. Do not use the Normalize analysis. Instead, use the "Fraction of total" analysis (new to Prism 6) and choose to divide each value by its row total and report the results as percentages. Then plot the results.

Using Prism 5?

If you use Prism 5, you'll need to use the stacked bar graph approach (Method 2) above. There is no "Fraction of Total" analysis in Prism 5, so you'll need to figure out how to do the math using the Normalize, Transform, Row means, or Remove baseline analyses.

Explore More GraphPad Prism Resources