The way you have it setup now is not the way it was originally, so there is your problem. It started with the charts on one sheet and the range on the other, but now with them both combined all on one sheet.

We can still work with this, but I really need to know how the data is actually layed out in Excel.