Cluster Stacked Column Chart Creator

An add-in for Microsoft Excel that builds clustered stacked column charts from ordinary data.

Download a trial version now!
  • Easy to use
  • Menu driven
  • All columns and clusters labeled so users know what they are looking at
  • Customize the resulting chart with your own colors and other formatting
  • Create different cluster stacked column charts from the same set of data

The Cluster Stacked Column Chart Creator add-in for Microsoft Excel makes creating cluster stacked column charts fast and easy.

The following is an example of a cluster stacked column chart:

Example cluster stacked column chart
A cluster stacked column chart

The data arrangement needed to create such a chart is llustrated by the following:

Source data for the cluster stacked column chart
source data (click to enlarge)
Chart data layout produced by the add-in
Chart layout (click to enlarge)

The entire process is menu-driven.

One of the key features of the Cluster Stacked Column Chart Creator is that it can easily create different data layouts, each of which can be used to create a different cluster stacked column chart view. In the chart illustration at the top, the data arrangement and chart view are clustered by quarters in a year, columns by sales regions, and stack by type of vehicles. This is arrangement 1 in the table below.

There are six data arrangements that one can have with the data for a cluster stacked column chart:

Chart components 1 2 3 4 5 6
Cluster: Quarters in a year Quarters in a year Sales Regions Sales Regions Type of vehicles Type of vehicles
Columns: Sales Regions Type of vehicles Quarters in a year Type of vehicles Sales Regions Quarters in a year
Stack: Type of vehicles Sales Regions Type of vehicles Quarters in a year Quarters in a year Sales Regions

To create a cluster stacked column chart of arrangements 2–6, one normally would have to manually re-arrange the data, which is painful. However, the Cluster Stacked Column Chart Creator can easily create the different data arrangements, and then you can use it to graph them. So, in just a few minutes of use, you can create six different cluster stacked charts from one set of data, not just one chart.

Customers who viewed the Cluster Stacked Column Chart Creator also viewed