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)).

Stacked-column-chart

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.

Delhi-Training-Excel-Stacked2



Share Now
September 19, 2013

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

    Leave a Message

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

    Tableau Training in Delhi

    All Rights Reserved. EC Analytics Consulting 2014 - 2019.

    NM 23, Sector 14, OLD DLF Colony - Gurgaon (Haryana) India. 9582876837 | Privacy Policy

    Drop us a Query

    Call Us: +91 8826547882

    Drop us a Query