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…

 

image

WANT TO WATCH RATHER THAN READ THE INSTRUCTIONS?

I placed a screencast that shows you how:  http://vimeo.com/9256645

 

STEP-BY-STEP INSTRUCTIONS

First assume our data set looks something like this …

 image

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:

image

In the properties for that Dataset, the Default Layout property is set to Table. Change this to Column Chart.

image

Now drag the Dataset into the Designs, node …

image

And a new AutoDesign will be created

image

Expand the nodes

image

To keep it simple, delete the “Revenue” node under Data

image

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.

image

Now preview the report …

image

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.

image

Change the Chart Sub Type from Plain to Stacked and then preview the report.

 

image

 

It looks ugly. We can fix that by applying a layout template to the report and a style template to the dataregion.

 

image 

And if you would like a 3D look. Set the Render in 3D property to True.

image

Which will give this look:

image

 

Maybe you want blocks instead of cylinders? Set the ThreeDStyle/Cylinder property to False

image

 

And now we have our final product: a nice column chart with stacked values.

image

 

 

SUMMARY GRAPHIC

The picture below is another guide to getting the desired chart.

image