Hoping there is a fix for this because its quite a frustrating issue. Happens on any chart with 2 dimensions.
On a chart with two dimensions doesn't seem to adopt any sorting prefernces picked on the second dimension.
On current example with have a chart with dimension of 'neighbourhood' and 'access to internet'.
The first dimension is to set to 'load order' which ensures neighbourhood are in alphabetical order,. However, we want to sort by the second dimension of 'access' with the scores showing in ascending or descending order (ie. Amblecote has 28.81%, whereas the next figure showing would be Falmouth (9.24%). Can't seem whatever we pick to get it to sort on this second dimesion, even unselecting all sorting on 1st dimension it makes no difference.
Promoting the 2nd dimension is not an option as it then changes how the chart looks.
Refer to the atatched and the chart in question is on 'sheet 3'