Super Comparison with Clustered-Stacked Chart

Share Now

Stacked column chart are good for comparison between categories and each category to whole. In stacked column chart each bar represents the total.

Here we are creating a clustered-stacked chart by which we can easily do the comparison between two categories (for e.g. below Planned and Actual scores of 2012 and 2013). Click Here to download the workbook.

Delhi-Training-Excel-Stacked1stacked chart in excel 2007

Step 1)      Create your stacked bar chart. (Select your data, click Insert Tab >  click Column Chart (under chart Panel) > click stacked column(under 2-D column)).


steps-to-create-chartstacked chart

In the above chart, we can easily compare the Actual and Planned scores for 2012 and 2013. It helps us in comparing the sum, but it not suited in comparison of each category against each other.

1)      Let’s do a little bit of data manipulation and create the clustered column chart, which will help in comparing data categories wise.

i)                    Rearrange the data table in the below format (insert few blanks series).

how to create stacked column chart

ii) Select the data and create the stacked chart as we created above.

stacked column chart

iii)  Let’s do the little bit beautification in the chart to make it more readable. Reduce the gap between the bars. Select the data series > do right click > select format data series > reduce gap width to zero.

how to format chart color

iv) Change the color of the data series to make it more readable and easy for comparing.


Share Now
November 15, 2019

0 responses on "Super Comparison with Clustered-Stacked Chart"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Social Media

    facebook page EC Analytics Consulting   Linkedin Page EC Analytics Consulting   Youtube EC Analytics Consulting


    0124- 4601426


    EC Analytics will help your business make better decisions by providing expert-level business intelligence (BI) services. Forecasting, strategy, optimization, performance analysis, trend analysis, customer analysis, budget planning, financial reporting and more. EC Analytics also offers Advanced Data Analytics training in corporate and retail.

    EC Analytics Consulting @ 2019 ALL RIGHTS RESERVED