Skip to Content
Former Member
Feb 24, 2011 at 11:20 AM

sorting in a stacked bar graph?


Hi experts,

I have a graph with [Region], [Year], [measure-sales]

I want to turn it to a stacked bar with Year on X and Region on Y. My problem is that I want to sort regions by sales.

If I turn the graph to crosstab I can order it by Sales for a column (for example, for 2009). That could work for me, but when I turn it to graph again, there is no sort.

I attach the graph.

Any workaround?

Thanks in advance,

Kind Regards,