Exchange the legend and the abscissa axis

[joc]

Hello everybody,

I need your help.

I have this data :

And I can have this graph :

But, I would like put the legend on the abscissa axis and put Q4 2015, Q1 2016, Q2 2016... on legend. I don't how to do that.

Thanks in advance for your help,

Joc 

[v-qiuyu-msft · Accepted solution]

Hi @joc,

You can open Query Editor, select columns NOTE_QUAL,NOTE_ENGA,NOTE_PROP,NOTE_PERT,NOTE_INST, then click Unpivot Columns, apply the changes. Then you can create a chart like this:

Best Regards,
Qiuyun Yu

[Seth_C_Bauer]

@joc You can add a calculated column IF or SWITCH that will create a number column that corresponds to the values you have in Trim. Then you can sort the Trim column by the calculated column.