How to reverse both series values when reversing categories

Question

I am using Excel 2016.

I have a horizontal bar chart (see screen shot) with associated table. I have created a secondary axis to overlay the green bars on top of the grey bars.  When I "reverse" categories to have them start from the top, instead of from x axis, the values of the primary series (grey bars) moves with the category change, but the values from the secondary axis (green bars) does not move with the categories.

Any advise to get the secondary series data to move with the primary data when I reverse the categories?  I have read some related posts for older versions of excel and can't quite figure this out!

Thank you in advance for you assistance!

Here is what it looks like before I "reverse categories"

Here is what it looks like after I set the "categories in reverse order) (I want Step 1 at top). Note that the Grey bars (primary series moves with categories but the green bars (secondary) do not move with the category change...

Answer 1

You need to add a second category axis too, and specify that the categories are listed in reverse order for this axis. Excel may spontaneously set the horizontal axis to cross at maximum category, set this to Automatic.

After that, you can delete the primary category and value axes.

Answer 2

OMG, that was so easy and I spent so much time on that. I can't believe I didn't figure that out.

THANK YOU AGAIN!!!