Which of the following would create a stacked bar chart?

Suppose you create a bar chart by dragging a dimension to the Column shelf and a measure to the Rows shelf.

Which of the following would create a stacked bar chart?
A . By dragging another dimension to the Rows shelf
B. By dragging another measure to Color on the Marks card
C. By dragging another dimension to Color on the Marks card
D. By dragging another measure to the Columns shelf

View Answer

Answer: C

Explanation:

Very important question for the exam and appears quite a lot too.

The correct answer is – By dragging another dimension to Color on the Marks card.

Chart, bar chart

Description automatically generated

This is what the question says we have already created. Now to convert this into a Stacked bar chart, we will drop another dimension on Color in the Marks card.

Chart, bar chart

Description automatically generated

The rest won’t create stacked bar charts, and hence are incorrect choices. The best way to answer such questions on the real exam is to quickly do what the options say and see if they satisfy the requirements in the question.