Sorting two data sets on Cluster chart

Hi,

I've been unable to find anything on this so thought I'd ask to see if it's even possible before moving on.

I'm trying to add a cluster chart to a worksheet which records 9 people in two different measures, with their final position in each. For example you may come 1st in one but 5th in the other. I need both series to be descending from 9 to 1 with your personal positions highlighted in each.

I can get one column to descend by sorting the data table it's pulled from, but it puts the two results together which leaves the second results out of order. Can they both be done descending?

Essentially i get the one on the left and what i need is on the right - is it possible?



Thanks