Bar chart order of data labels Y-axis

[Legacy 108787]

I have a few small bar charts containing data from a survey such as Yes/No/Maybe questions. They are listed in that order (first Yes, then No and Maybe is the last option). When I use this data to make a bar chart, the data on the vertical axis is ordered the other way, Maybe on top, then No, then Yes.

If I go to Format Axis I can tick "Categories in reverse order" but that puts the horizontal axis (and its labels) above the graph.

I can fix this my changing the order of the source, but that's not only a very dirty solution, it also messes with the fomulas I use to get the data (shifts ranges).

Any ideas? I use Excel 2007.

 

[Andrew Poulsom]

You can also check "Value (Y) axis crosses at maximum category".

 

[Legacy 108787]

You can also check "Value (Y) axis crosses at maximum category".

Check. Wording is a bit different, but that's what I was looking for. Thanks! :D