How to set starting value for x-axis for a chart which starts in the middle of y-axis?

[foxx1]

Hello!

I am using area charts to visualize the area between 5%-quantile and 95% quantil. This area chart has to start in year 2011 (y-axis) but the whole y-axis goes from 1971 to 2099.
I'm having a problem which you can see in this picture (red box): http://www.fotos-hochladen.net/view/fragezpm84dvagy.jpg

As you can see, it seems that the area chart is starting at value 0 and then goes to the value of year 2011. The result is that the begin of the area on the left side seems to look oblique. What can I do to eliminate this problem?

Thank you in advance!
foxx

[Andy Pope]

You need to include 2 entries for the period where the area starts to get a clean vertical line rather than one starting from zero.
move the areas to the secondary axis

[foxx1]

Thank you for your answer

Right now I dont know how to this. I have added my excel file as attachment. When I do it your way, my diagramm gets distorted in different directions :D

Think will need some more help

[Andy Pope]

First your years are not dates but just numbers. So change the values to be used on the secondary axis.

You need to move the 2 area series to the secondary axis. The set the secondary axis labels range via the select data dialog.
Finally set the secondary axis to Date type

[foxx1]

Ah, I understand now. Thank you very much, Andy!