Axis title high-low option for charts.
For some unknown reason, excel chart always flips my data so that the first data point is at the bottom of the y axis. As a result, I always have to select 'reverse order' so that the data appears in the order that I type it. Annoying, but not a major problem. However, the x-axis title is now always at the top, and there is no option to select 'high' to place it at the bottom of the chart.
I’m not able to reproduce the problem you are describing. Can you send me more explicit steps that are needed to reproduce it and a sample file?
Jon Peltier commented
The OP is talking about a horizontal bar chart, so the category labels are on the vertical axis, but it's still the X axis.
Excel plots the first category next to the chart's origin, which is the bottom left corner where the axes intersect. The second category is next to that, and so on. Starting at the origin, categories in a column chart go left to right, which seems normal. Starting at the origin, categories in a bar chart go bottom to top, which has always seemed normal to me (knowing about that whole origin thing) but confuses most people.
The way Excel would best address this without messing up existing charts and existing chart code that knows about the chart's origin, would be to default a bar chart to having Categories in Reverse Order checked and Crosses at Maximum selected.
The vertical axis goes from bottom to top. I usually have to reverse the order in order for the y axis to go from top to bottom. Thanks. Will try to post an example, but this is how charts work, for me at least.