I have a chart with month/year as the X-axis and two data series on the Y-axes. Due to how my date data is organized, I need to reverse the order of the x-axis when it is displayed in the chart. I can do this without trouble using the Reverse Category Order on the x-axis. My problem is that when I change my second data series to show up on a secondary y-axis, this data series reverts back to the original sort order on the x-axis (but the first data series remains the correct way).

I need to find a way that both data series reverse their order so that they follow the x-axis. Can someone tell me what I'm doing wrong?

Thanks