How to create a chart with Data not Next to each other
http://www.xlninja.com/2012/08/06/how...
In an ideal world, you would have data in an spreadsheet set up in such a way so that Excel can easily create a chart.
Sometimes however you might need to keep the data not next to each other and this makes building a chart a little trickier.