I have a bar chart with 2 series(one sql in each series ) and the x axis is showing the data in un-ordered format even though the x axis is sorted by label value as ascending .
Please refer the images for details and help me in solving this issue.
output : 6th , 7th hour etc values are showing at the end .
x - axis properties
query output for series 1:
| NULL | HOURS | COUNT(*) |
| | 5 | 1 |
| | 6 | 4 |
| | 7 | 410 |
| | 8 | 1261 |
| | 9 | 248 |
| | 10 | 102 |
| | 11 | 60 |
| | 12 | 38 |
| | 13 | 17 |
| | 14 | 10 |
| | 15 | 4 |
| | 16 | 1 |
| | 17 | 1 |
| | 19 | 1 |
| | 24 | 1 |
query output for series 2 :
| NULL | HOURS | COUNT(*) |
| | 5 | 1 |
| | 6 | 4 |
| | 7 | 410 |
| | 8 | 1261 |
| | 9 | 248 |
| | 10 | 102 |
| | 11 | 60 |
| | 12 | 38 |
| | 13 | 17 |
| | 14 | 10 |
| | 15 | 4 |
| | 16 | 1 |
| | 17 | 1 |
| | 19 | 1 |
| | 24 | 1 |