Exceltechie.com

Easiest way to learn excel on the planet
Facebook-exceltechie Twitter-exceltechie Linkedin-exceltechie
|| Novice || Beginner || Intermediate || Advanced || Specialist || Expert ||
Types of Charts ***Page under construction
Column     Bar     Line     Pie 
Area     Scatter     Other Charts     More Chart Types 
Cluster Column Chart details
Warning Column Chart is best suited to display data that shows comparison of two or more variable It may also be used for showing the trend of a single variable x-axis - Time Series
Column charts have 3 variants
Cluster Column Chart - One nex to another
Stacked Column Chart - One above the another variable in the same column
100% Stacked Column Chart - One above the another variable but displayed as % to 100
Chart details
Cluster Column Chart
Cluster Column Chart details
Warning There may be situations where you would have to create secondary axis

When plotting secondary axis in a column chart it is advisable to color code the secondary axis line and the Secondary axis font with the same color for better understanding and differentiate primary with secondary