zaterdag 2 november 2013

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 columnSeries overlap 100 % and Gap width 200%.

Both Total Amount series are plotted on the primary axis. Graph type columnSeries 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
Een reactie plaatsen