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.
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.