A typical question entered my inbox last week – how does one create a stacked column chart that shows multiple series. The image below shows what is desired…
I placed a screencast that shows you how: http://vimeo.com/9256645
First assume our data set looks something like this …
NOTE: I added an extra “Revenue” column, to make it easier for me to use this dataset in future examples, you can ignore it for this blog post.
Thus in the report model it will be seen like this:
In the properties for that Dataset, the Default Layout property is set to Table. Change this to Column Chart.
Now drag the Dataset into the Designs, node …
And a new AutoDesign will be created
Expand the nodes
To keep it simple, delete the “Revenue” node under Data
Drag the Year node from the Data node into the Categories node. Then drag the Company node from the Data node into the Series node.
Now preview the report …
Ugly and we are missing the stacking; but at least the data is organized correctly. .
Select the Dataregion (the node called “Dataset_CompanyFinancialsXYChart”) and examine its properties.
Change the Chart Sub Type from Plain to Stacked and then preview the report.
It looks ugly. We can fix that by applying a layout template to the report and a style template to the dataregion.
And if you would like a 3D look. Set the Render in 3D property to True.
Which will give this look:
Maybe you want blocks instead of cylinders? Set the ThreeDStyle/Cylinder property to False
And now we have our final product: a nice column chart with stacked values.
The picture below is another guide to getting the desired chart.