Question-Super Imposing Line over stacked
I have used a line chart over an stacked chart and i have used the secondary axis for the line chart. The idea of doing so is that the line chart controls my sales data and the stacked chart shows me the spend on different sectors. both the charts are controlled by a combo box for months. When i try to change the months the charts behave in a haphazard way with the axis moving over one another. how do i resolve such an issue ?