Column Chart with a Difference  (This method applies to Excel 2007 and later)


Column 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 Excel  file showing how to make these charts.










Return to Tips and Trick Index