My graph looks like this:
It is actually fairly simple to create this.
Here are the data from A1:E6:
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
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
Reacties