Column Chart with a Difference

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.