How to combine multiple charts in one?

[papaja]

Hi,
I have attached Excel file. I want to create ONE chart object to represent data. This sheet contains sample revenue data by weeks of the year for various partners. I want to visualize how total revenue behaved during the year 2013 compared to year 2012 and in the same time how much each partner contributed. I believed that I can create stacked area chart for one year, and somehow add stacked column chart over it and I managed to do it, but:
1. I have to manually paste new series;
2. I have to manually click on every added series and convert it to another chart type, which is imprecise, and cumbersome;
3. I have to manually change color of added series to match color of that partner from last year, which is almost impossible;
4. I have to manually adjust legend as it should contain each partner name and color only once.

How can I do it more automatically?