When creating a double axis horizontal chart that are both clustered bar, excel formats it correctly in that the primary axis is on the bottom (horizontally) and the secondary axis is on the top (horizontally). However, when i change one of the data series into a line chart, the horizontal axis will move to the vertical axis which is not what I want. Do you know how to keep it horizontally?

Excel creates double axis chart correctly
2Cluster.jpg

Excel incorrectly moves the secondary axis to the vertical position to the right but i want to keep it at the top!
combo.jpg