I would like to create a column chart with reversed Y axis, but where the columns rise from the bottom.
This is to achieve a visual representation of a ranking, where 1 is top and 18 is bottom (see the attached mock).
What's the best way to achieve this?
I know how to reverse the Y axis but can't figure out how to keep the columns rising from the bottom of the chart. Thanks for your help!