Another way to represent the third dimension of data is through stacking. In this way, a single bar on the chart can show data for more than one category of data. For example, a single bar can represent the amount of sales for CD-ROM drives in one year on top of a bar representing sales for other years. You can stack the bar charts vertically or horizontally.
Stacked bar charts show the relationship of parts to the whole. Stacking techniques differ depending on whether you are Stacking Categories within Data Labels or Stacking Categories of Numeric Data.
Stacked bar charts offer similar complexity to clustered bar charts by adding component value items within chart bars or areas. By stacking items and assigning a different color to each item, you can effectively display trends among comparable or related items, or visually emphasize a sum of several indicators.
To create a Stacked bar chart, you need more than one Request item in the Y‑Facts in the data layout. Each value item adds a segment to the length of the bar.
To display bar values: