First I worked out the example with a split Y-axis with the Y-axis left and right. Then I saw Jon Peltier already did this: http://peltiertech.com/WordPress/broken-y-axis-in-excel-chart/
So I had to try to get them on the same side:
Too late to explain.
You can also download the file splityaxis.zip through this link: