Excel: Column Chart Combined With Stacked Column Chart

My graph looks like this:

It is actually fairly simple to create this.

Here are the data from A1:E6:

	Total Amount	Apples	Pears	Banana's
1-1-2004	495	155	165	175
1-1-2005	685	195	215	275
1-1-2006	900	275	300	325
1-1-2007	1110	275	350	485
1-1-2009	1200	300	400	500

In my graph I added 5 series:

So I added Total Amount twice. The last three series are all plotted on the secondary axis and the graph type is stacked column. Series overlap 100 % and Gap width 200%.

Both Total Amount series are plotted on the primary axis. Graph type column. Series overlap 0 % and Gap width 0%. The second Total Amount series has no color.

The X-axis is formatted as a date axis. The dates are formatted as year, jjjj (in my Dutch case).

You can also download the file columnstackedcolumn.zip through this link:

https://drive.google.com/folderview?id=0B7HgkOwFZtdZVmhRQUZFM28yc1U&usp=sharing