Formatting Stacked Column

[mgregory24479]

I am interested in formatting the attached stacked charter where the smaller section of the stacked chart (I have the series set to (Above/Below) and I want the Below on the on the bottom. I have tried several different processes to make this change.

One example is I said if it's Above, then 1 else 2 and added that is my sort, but it still doesn't make the adjustment. Any suggestions are greatly appreciated.

[Francis aka khayman]

when you sort your Series with values "Above" and "Below" you are sorting based on the letters of the values, not the values....  :o :-\

Ok ok... let us say:

Above = 100
Below = 200

When you sort Ascending it will be: Above, Below
Sort descending and it will be: Below, Above

sorting is based on the label of your Series not its value

Now I guess what you want is to sort on values 100 and 200. So you need to set the sorting order based on your measure.