How to display Y-Axis in Clustered Bar Chart value based on hierarchy

[NickzNickz]

Hi ... 

I have created the below table and clustered bar chart output. 

Based on the information below, how can I ensure that the Y-Axis value should follow the correct hierarchical position as in the table?

Thank you in advance.

Regards,

NickzNickz

[Ritaf1983]

Hi @NickzNickz 
You have to add a column to allow you to sort by role.

Then to modify roles sort by this column from the data view:

Then put your data on graf sorted by role:

Link to sample file 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[NickzNickz]

Hi ... Thank you for your help ...  You also provide me with the SS too ...  Really appreciate it... 

Regards,

NickzNickz

[Ritaf1983]

Happy to help 🙂
You can mark more than 1 response as a solution.

[Kishore_KVN · Accepted solution]

Hello @NickzNickz , 

For this you have to create a order or index column for the management. This will help you in sorting. 

After creating order column your data looks like this:

>>  Then select Management column and in column tools click on sort by column and select order column.

Then output looks like this:

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

[NickzNickz]

Hi ... Thank you for your help ...  Really appreciate it... 

Regards,

NickzNickz