View source for Stacked clustered bar charts

[[Category: Graphs]]

__TOC__

==Creating stacked clustered bar charts==

To create a stacked clustered bar chart, you'll need two variables:
# The final result. (which will be depicted as the height of each bar segment). In the above, this is Variable <code>Data</code>.
#: This needs to have at least three dimensions.
# The segment labels. In the above graph, this is Variable <code>Combinations</code>.
#: 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:

:<code>Actual_or_forecast & ' ' & Technology</code>

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:
# Show the result graph for your final result (Data).
# Double-click to bring up [[Graph setup dialog]]
# Select Bar style and check Stacked Bars. Press '''Apply'''.
# Press the [[image:XY.png]] button at the top-right corner of the result window
# Add the variable you created for the labels (<code>Combinations</code>) to the '''Use another variable''' list. Then close the ''Comparison Sources'' dialog.
# Set '''Color Key''' to your label variable (<code>Combinations</code> in the example).
# Select the Stack and Cluster dimension as desired.<br/><br/>

:[[image:Stacked clusters.png]]

Download the "[[media:Stacked clustered bar chart.ana|Stacked clustered bar chart.ana]]" example model.

==History==
Introduced in [[Analytica 4.6]].

== See Also ==
* [[media:Stacked clustered bar chart.ana|Stacked clustered bar chart.ana]]
* [[Graph settings]]
* [[Graph setup dialog]]
* [[Heat  maps]]
* [[Contour/Region Charts]]
* [[Waterfall Charts]]
* [[Analytica_Modelers_Guide#Mini-Tutorials|Mini-Tutorials]] where other esoteric graph types are described.