How Can I Flip an Axis WITHOUT Visually Flipping a Chart

Question

I have a chart in Excel which looks like this:

The problem is that with my data, 100 is the lowest possible rating whilst 1 is a much higher score. As such I want the chart to have 0 at the top of the vertical axis and 100 at the very bottom.

Normally I'd reverse the vertical axis but this causes a boatload of problems visually and things which I didn't specifically ask Excel to do:

1.) the bars are all going down which visually looks negative if I wanted to show success. I need the bars to go up not down!

2.) Since 100 is the lowest score, the 'filling' (visual formatting of the bars) should stretch from 100 to the designated value, not from 0 to the designated value as current which is completely wrong

3.) basically the transparent parts of each bar (column) should be filled and the filled parts of each bar (column) should be transparent so visually it needs a complete inversion in terms of bar colour filling

This is what I want the chart to look like in-case I confused the heck out of you:

If you compare the first and third images from this post (the top and bottom images, not the one in the middle) you will see they are the same except for the axis order and bar inversion which I had to create manually in MS paint!

How can this be achieved? Pulling my hair out, have been looking for literally hours to just get this one chart right and (sadly) I really can't do it on my own. Any help would be GREATLY appreciated!

I am using Windows 10 64 bit with MS Office / Excel Pro Plus 64 bit 2016

Answer 1

So easy, Just do your chart normally, then R-Click the values Axis & select (Format Axis). From Axis Options pull down @ Horizontal axis crosses tick the (Maximum Axis Value) Radio button.