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