Reverse Sorting order in the bar chart (stacked)

[#1]

Hi,

we are having a Age band with the below values. If we add this Age Band in a list box, The sort order will display correctly.

Age Band
0 to 10,
11 to 20,
21 to 100

We are adding this AgeBand in a Bar Chart (stacked), which is having two dimension. After this the values is coming reverse (i.e  21 to 100,11 to 20,0 to 10). To correct this we have to set the sort order in reverse (i.e Z-> A) and it displaying correctly.

In our QVW business needs the option for fast change of line graph, as the sort order is set for 'Z-A', the sort is reversing  in the line chart (i.e  21 to 100,11 to 20,0 to 10).

Note : If the bar chart is not stacked it will display the sort order correctly.

I have attached a sample QVW. Please could you have a look and advise.

Please let me know if any more information is required.

Thanks,
sijo

[billbois]

I wish I had a solution for you.  I'm having exactly the same problem.  Have you been able to figure out a solution since posting this?

Thanks,

Bill

[Chris_Rice]

This unfortunately is "As Designed".  The only work around so far is to create two different charts so you can use the "Reverse" function on the legend of one to make the legends the same.  I would encourage you to open an "Idea" to get this functionality in the future.