You have a bar chart that has a dimension on the Columns shelf and a measure on the Rows shelf. How can you make a stacked bar chart?

Question

Exhibit

Options

• ADrag another measure to Color on the Marks card.
• BDrag another measure to the left of the measure on the Rows shelf.
• CDrag another dimension to Size on the Marks card.
• DDrag another dimension to Color on the Marks card.

• A
  7% (3)
• B
  2% (1)
• C
  2% (1)
• D
  88% (38)

Explanation

Dragging another dimension to Color splits each bar into colored segments based on the dimension's members, creating the classic stacked bar effect. Option A is wrong because adding a measure to Color encodes a continuous gradient across the whole bar rather than discrete stacked segments. Option B would create a side-by-side (grouped) bar chart with separate bars, not stacked ones. Option C adds a dimension to Size, which controls bar width - not stacking.

Memory tip: Think "stack by category, color by category" - stacked bars require a dimension (categories) on Color to break each bar into labeled slices. If you ever mix up A and D, remember: measures give you a color spectrum, dimensions give you color segments.

No community discussion yet for this question.