Two Y Axis's One X, Chart Data not in sync with X axis between Y axis's

I have a stacked bar chart with a closing price line chart superimposed over these bars. There is a png image attached to this post. Line are the series of circles.

All data is linked in "Data Source" to the dates in the X Axis. The data in this axis is reversed so the most current data/date is displayed on the far right hand side of the chart.

Because the line chart represents the closing price of the stock it is on the secondary axis displaying prices on the left of the chart. Percentage bars are on the primary axis display 0 - 100% on the right.

My problem is the closing price line chart (the series of small circles plotter over the bars) is plotting backwards? The most current data for the date is plotting on the far right hand side of the chart not the left as all of the percentage bars are correctly doing.

Can anyone offer a suggestion?



Thanks, Michael

If you go to charts > chart formats and view Axis you can select and alter the secondary horizontal axis even if it is hidden or set to none.