I have an issue when combining to chart-types (column and area) into one chart. The Column-chart is using Y-axis 1, the Area uses Y-axis 2.
The Area-chart is used only to mark a periode of time (along the X-axis). And the value of the Area-chart series is always "1". The Column-chart has both positive and negative values.
So, the problem is that the Area-chart is using the 0-value from the Y1-axis, not the Y2-axis (which it does belong to). The included picture demonstrates this more clearly.
Can anyone give me a hint to how to make the Areachart start on its own 0-value (from the Y2 axis), instead of the Y1's 0-value?