rearrange a clustered column chart base on an unused column

[aqlmarin]

Hi,

I have the data table with say 3 columns, 1 is categorical and the other 2 are numerical. for example something like this

name    score   age

a            20        16

b            25        12

c            18        15

I want to plot score on name, but i also want to sort them by their age in ascending order, however, i don't want to plot their age. As a result, my desired bar graph would be arranged as [b, c, a], with only their scores getting plotted

Thank you very much,

[lbendlin · Accepted solution]

put the age in the tooltips and then sort by it