L
Legacy 108787
Guest
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.
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.
