Horizontal bar chart is a little bit odd, because it has X and Y axes reversed.
Now I have four horizontal bars need to display:
- 3 and 4 years old
- 5 and 6 years old
- 7 to 13 years old
- 14 to 17 years old
When the four bars are put on the axis, they are sorted into:
- 14 to 17 years old
- 3 and 4 years old
- 5 and 6 years old
- 7 to 13 years old
Apparently it is because "1" is sorted ahead of other numbers.
There is "Indexed" may put the categories in original order, but it only works on X axis, but in bar chart the category is on Y axis. So it does not work for bar chart.
Is there anyway I can show the bars in the original order of the points of the bar series?
Thanks!
