Stacked bar chart

[manoranjan_d]

Hi all,

I m using stacked bar chart, in that no dimension and i m using only expression, now i want to sort the value from low to high

how can i do that in sort tad?

pls help me

[vincent_ardiet]

Hi,

I you have only 3 expressions, it's feasible.

I have done a test.

- Create 3 variables containing each of your expressions, I've called them exp1, exp2 and exp3

- In the bar chart create 7 expressions containing in this order:

   $(exp1)

   $(exp2)

   $(exp3)

   $(exp1)

   $(exp2)

   $(exp1)

   $(exp3)

- Then for each expression use the following condition to display them   

1. $(exp1)>=$(exp2) and $(exp1)>=$(exp3)
2. $(exp2)>=$(exp3)
3. ($(exp1)>=$(exp3) and $(exp1)>=$(exp2)) or ($(exp2)>=$(exp3) and $(exp1)<$(exp3)) or ($(exp1)<$(exp3) and $(exp3)>=$(exp2))
4. ($(exp1)<$(exp2) and $(exp2)>=$(exp3)) or ($(exp1)>=$(exp2) and $(exp1)<$(exp3))
5. $(exp2)<$(exp3)
6. $(exp1)<$(exp2) and $(exp1)<$(exp3) and $(exp2)<$(exp3)
7. $(exp1)<$(exp2) and $(exp2)>=$(exp3) and $(exp1)>=$(exp3)

With more expresions it will become really tricky.

Regards,

Vincent