Column Chart with a Difference(This method applies to Excel 2007 and later)
charts are frequently used to compare different data sets. It takes a
little trick to have Excel make more than one stack but it can be done
– see figures below. The file Columns2007.xlsx is an Excelfile
showing how to make these charts.