Set legend and bar chart order other than alpha or numeric.

[lbrosten]

My bar chart is made up of High, Med and Low. I want the bars to sort top to bottom, High (Light Blue), Med (Red),  Low (Blue) and the Legend order to be high, med, low.  Sort by Number or Alpha doesn't work. If it is expression what would expression be?

[chaorenzhu]

use dual() for your legend field in your load script, something like if ("Contact Method"='High',dual('High',1), if ("Contact Method"='Medium',dual('Medium',2),dual('Low',3))) as "Contact Method"