Excel Stacked Bar Chart : Choosing the Right Chart Type

Column charts can display both nominal and ordinal data, and stacked column charts can be used to display data with a part-to-whole relationship instead of a pie chart. Excel Stacked Bar Chart work better when you want to compare the whole and distinct parts.