How to reverse axis in an excel chart
There is data for the top 10 islands in the Caribbean.Let's look at how the data is plotted in excel.
The first and last columns match the order of the source data moving top to bottom.
A line chart and area chart don't make sense for this data, but if I temporarily try them out, you can see the plot order stays the same.
The category labels start next to the origin and each new value is plotted further away from it.
The bar chart's layout makes it look like the data is reversed since the values are plotted from the bottom to the top.
Near the bottom, you'll see a button called "values in reverse order".The plot order is reversed when I check the box.
Cuba is in this case because the horizontal axis is set to cross at the minimum or first value.The axis moves along with Cuba when I reverse the order.
If you want to reset the axis to it's default, you have to visit axis options again.