Reversing Secondary X Axis Category Order

I am building a table with two data sets over a range of months. Like so:

Month	Data 1	Data 2
April	45	2.1
March	62	1.5
February	40	2.3
January	37	2.7
December	83	2.6
November	96	5.6
October	94	6.4
September	46	4.0

When I format it into a "Clustered Column - Line on Secondary Axis" table with default "Standard" formatting, it shows up properly with both axis displaying their own data sets. However when I try to reverse it into chronological order (by using the "Categories in reverse order" tickbox in Axis Options), only one data set (Data 1) gets reversed and the other (Data 2) stays the same. This causes my data to be inaccurate because Data 2's values do not match with their appropriate month.

tO7Xl7u.png

I have found that when I change Data 2 to show on the Primary Axis with Data 1 it reverses normally. This leads me to believe that I need to reverse the data on Data 2's Secondary Axis, but I cannot see an option to do that.

Any assistance in letting me know what I'm doing wrong, or how I can format this table properly is greatly appreciated.

In order to change the order of the secondary x axis, you first need to display the secondary x axis. With one of the series formatted on the secondary axis system, find the "axes" command in the design group, then tell it to display the secondary horizontal axis. Then you can apply the desired formatting to the secondary horizontal axis.