# Stacked clustered bar charts

## Creating stacked clustered bar charts

To create a stacked clustered bar chart, you'll need two variables:

1. The final result. (which will be depicted as the height of each bar segment). In the above, this is Variable Data.
This needs to have at least three dimensions.
2. The segment labels. In the above graph, this is Variable Combinations.
This needs to share at least two dimensions with the final result.

The real "trick" to creating a stacked clustered bar chart is in designing effective labels. If you select arbitrary labels, it won't be clear to the viewer of the graph as to why there is a separation between stacks and clusters. In the above graph, this was accomplished by appending the labels from the two indexes:

Actual_or_forecast & ' ' & Technology

You should also limit the number of distinct labels to 30 or fewer. Values with more than 30 unique labels cannot be used in the color role.

Once you've created both variables, follow these steps:

1. Show the result graph for your final result (Data).
2. Double-click to bring up Graph setup dialog
3. Select Bar style and check Stacked Bars. Press Apply.
4. Press the button at the top-right corner of the result window
5. Add the variable you created for the labels (Combinations) to the Use another variable list. Then close the Comparison Sources dialog.
6. Set Color Key to your label variable (Combinations in the example).
7. Select the Stack and Cluster dimension as desired.