Stacked vs Clustered: choosing the right column chart

##Start with the right question

Before selecting a chart, ask yourself: what question am I trying to answer with this data?

If the question is about understanding the proportion or contribution of each category to a total, a stacked column chart is the right tool. If the question is about comparing categories side by side to see which one performs better, a clustered column chart is the better choice. A clustered chart lets you compare not just across fields but across individual items.

##Example: fruit sales

Imagine you run a fruit-selling business offering mangoes, oranges and apples, and you want to see monthly sales.

With a stacked column chart, each month becomes one column and the three fruits stack inside it. You immediately see the total sales per month and roughly how much each fruit contributed to it. What you lose is precision: comparing oranges in March against oranges in April means comparing two floating segments that start at different heights.

With a clustered column chart, each month shows three columns standing side by side. Now comparing any fruit across months, or the fruits against each other within a month, is effortless, because every column starts from zero. What you lose is the total: there is no single bar representing the month as a whole.

##How to decide

• Use a stacked column chart for proportions and part-to-whole relationships. The total matters, the exact segment values matter less.
• Use a clustered column chart for comparing values across categories. Precise comparison matters, the total is secondary.
• If you need both, consider showing the total another way: a line over the clusters, a label, or a separate card.