Column Chart with a Difference  (This method applies to Excel version prior to Excel 2007 – see the other entry for later Excel versions)


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 DoubleColumn is an Excel  file showing how to make these charts. The method is taken from Stephen Bullen’s page but the instructions have been expanded.


Description: Description: DoubleColumn




Description: Description: DoubleCol2Another example of a "double column" chart











Description: Description: DoubleColText

Description: Description: ufopanelReturn to Tips and Trick Index